Forum

Hi Nicola, I can't reproduce any of your issues. If you click the link you pasted to the NASA API it returns JSON data. Therefore the error you...

Hi Nicola, without your code I can't do much to help you. Phil

Hi Chris, Load your file to Google Drive or OneDrive and then post a link to it. Phil

Hi Ayal, I'm using Edge too but don't have that issue. Not sure why you are but I'll investigate. In the meantime, just use the frontpage of th...

No file attached. Click the Start Upload button after selecting the file

Hi Mike, The connector only allows you to load the data into a table or a pivot table. You'll have to do that then load the table into PQ, do yo...

Hi David, You could use VBA but is that what you want? Maybe if you supply an example of what you are actually trying to do we can understand yo...

Hi Barbara, The Sort_By column is created based on your logic and the contents of the Sorter column. So if you want things sorted differently you ...

Hi Barbara, Yes I would say there's probably a way to do what you want but I'm not entirely sure what it is you want. In the image you supplied ...

No worries - glad you found the answer! Phil

Hi Sheralee, No workbook attached. Click on the Start Upload button after selecting the file. Phil

Hi Nesha, Surely it's in your colleague's best interest to learn skills that make their job easier? Why persist doing something the old way just b...

Hi Nesha, Why don't you want to use Power Query? It would make things much easier than using formulae. Regarding the formatting of the numbers,...

Hi Samir, Hard to help with that since it's out of context. Need all the other code around it to see why it isn't working. Phil

Hi, He may have written the code in the editor but I didn't see him run it. If he ran it, it would generate an error because it is incorrect. I a...