Forum

Hi, You can just add a new column with this formula, assuming that your data is in range A2:A1000: =AND(COUNTIF(A$2:A2,A2)=1,COUNTIF(A$2:A$1000,...

Hi Shawn, You should use dependent dropdowns:

Hi Sherry, Is there a reason why you need to split data into sheets? Most of the times, data is best used if it's in one place.

Hi Simon, Hard to imagine your structure without a clear image. From your descriptions, I assume that there is a set of port2.pdf files, are the...

Hi Simon, When you reference a query, it normally looks like this: let Source = Table1, in Source (where Table1 is a reference to a ...

Hi Andy, If you want to add a text to a textbox, just select the textbox then go to formula bar, type the = sign then select the cell from the othe...

Hi Gigi, In vba, you cannot search a range for shapes, we can only search in sheet shapes (For each Shp in Sh.Shapes). I provided the easiest wa...

Hi Gigi, To copy a cell that contains an image, you have to make sure that the image is included completely in that cell, not spread across multipl...

Instead of removing null dates, sort tasks and phases properly and Fill down the date column, for Task1 as an example it will populate Phases 3-5 with...

Hi Marsil, These parameters are based on the window, not on the sheet, so you have to store the parameters from the source while it's active, then ...

Hi Helena, In this loop, I think it's best to exit when SlicerverdiIndex + 1 exceeds the SL.SlicerItems.Count, my guess is that you have reached th...

Hi Agim, To upload files, look after the Attachments button when you add a message, it will allow you to select the files then Upload them attached...

Hi Shawn, Hard to debug based on images, if you can attach a sample workbook that can reproduce the problem will be easier to check. I would che...

Hi Christine, This feature is available to Beta Channel users running Version 16.50 (Build 21050400) or later, as mentioned here: Hopefully it w...

On Tools>Options>Editor Format, you have to select from the left side list the TYPE of text you want to change: Normal Text, Selection Text, Com...