Forum

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

Hi Salim, I haven't used Excel 2016 in a long time so not sure if this will work, but have you tried what's suggested in this post Play Audio an...

Hi Lea, I'm not getting an issue I'm afraid. When I run your query I get 59 rows loaded into excel. Regards Phil

Hi, Please supply your file so we don't have to recreate it. Thanks Phil