Forum

Hello, How to enable the Legacy Wizard in Excel for Microsoft 365. Br, Anders

Hello, I have borrowed the sample file that Riny uploaded, added two helper columns and use the first helper column to find matching data. See atta...

Hello, See attached example file for a slightly different approach. I can't say why you get the Not in Scope data in count, but you do have tbl_dat...

Hello, Not sure why you need a macro to print, just arrange the data you want to print and press Ctrl + P (Windows) or Command + P (Macintosh). ...

Hello, You can try out this feature. Br, Anders

Hello Lea, Your data validaton rule in cell A1 is =COUNTIF(DATA!A:A,A2)=0, which means that as long as cell A2 is empty or have allowed vaule (one ...

Hello Amol, Not sure how you get the Please verify result on all rows, as it works just fine for me. Br, Anders

Hello, The error message states that you have duplicate entries in both columns. It also states that at least one of these columns need to have uni...

Hello, Just came to think about your issues with this picture lookup this morning. I did mention in my first post that it is not the pictures you a...

Hello, I don't have Office 2019 so thus don't have the new context menu options as shown in your picture. Did you check the guide I linked to in my...

Hello, As Jessica writes, you need VBA if you want to count by colour, but why bother when you can use the same criterias used in the CF rules and ...

Hello, Regarding the Fan5 issue, it was because I had forgot to name cell B6 to TDF_Image. Works fine after that was fixed. I copied the Images ...

Hello, Without a sample file we can't look for any errors, I mean, if the expected result is 0 and you get those numbers, then there must be some c...

Hello, See attached file for an example. Type in (or paste) the below nested IF formula in cell C3, then drag and copy to the remaining cells. ...

Hello, No picture. Not sure what context menu options you want to get rid off, perhaps this guide can give some help. Br, Anders