Forum

Try these posts Running totals in Power Query Grouped Running totals in Power Query Regards Phil

Hi Michael, You can check the Description column for words that indicate the value in the Revenue column should be negative, e.g. look for "Discoun...

Hi Jan, I'm not sure if you are asking me something? regards Phil

Hi, With this Power Query course Regards Phil

Hi Francis, I understand this might be difficult as you don't know how to create a pivot table, but there's no substitute for learning. So I'd rec...

No worries. Phil

Hi Adam, Offie 365 would be better as it provides the best solution. Without that you'll have to rely on techniques shown here Excel Extract a Uni...

hi Paul, No file attached. Click Start Upload after selecting the file. regards Phil

Hi Salim, Please be specific as it will help us help you. How exactly is it not working? What have you tried? Did you get an error message? C...

Hi Moshe, If you are referring to the name of the source file in your query steps, then you change that file name, it's going to break the query be...

Hi Adam, What version of Excel have you got? If you can use dynamic array functions you can solve this using =UNIQUE(FILTER(Table1[NAME],NOT(IS...

and what about my questios as to whether you want a vba solution?

Hi Lea, I don't know. That error message does not make any grammatical sense, are you translating it from Hebrew? It would make sense if it read ...

Hi Amin, No file is attached, please try again and click on the Start Upload button to load the file. Also, you've posted this in the VBA forum....

Hi Adam, I'm afraid it's not clear what you are asking or what you want to achieve. I've looked at the file and an see in Step 3 that you have c...