Forum

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

Hi Lea, I don't have any problem loading a table off that website using a new query - see attached file. Can you please supply your file so we c...

Hi MGB, I don't understand what you are trying to do. Maybe if you actually explain what your desired end result is - and supply a file with that ...

You can also use the IN operator when you want to use OR logic. = CALCULATE( sum([amount]), FILTER( 'AP-RAW', ...