Forum

Hello Edward, If you can elaborate on what issue you have, even better if you can upload a sample file where the issue is clearly shown, so that we...

Hello, Great job! I am just glad that I could give you some assistance. Have a great day! /Anders

Hello, Sorry, English is my second language and I may have missed some nuances in what I wrote to what I tried to say. What I tried to say was that...

Hello, I have some questions. Where do you want to add a row? What is the issue when adding the row where you want it? What was suggested that d...

Hello, The file seems broken, I can’t download it. Go to the blog section and search for running, you will get some articles to read. Here is on...

Hello, The photo is not showing a Pivot Table, it is just a range of data. As per the picture the data is manully entered in the cells, at least th...

Hello Fred, Not sure if this is a good approach in the long run, but at least it works with this small amount of data, even though you have to upda...

Hello, In the Excel table, change all Yes values to 1 and the No values to 0, then change calculation in the Pivot Table to sum the values instead ...

Hello, If you are interested to learn then I do recommend Mynda's Power Query course, it is well worth the time and money you spend to learn the ba...

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 ...