Forum

Hi Sarfraz You can use Power Query to do this, as explained in this tutorial. Mynda

Hi Tom, Thanks for sharing a file with your before and after results. I wish everyone would do this! That said, I think there may be some errors in...

Hi Mohamed, Thanks for providing the file. I've converted the data in the Forecast sheet to a table and replaced the dynamic array formulas with st...

The Power Query editor gives you a 1000 row snapshot of the data. It does this to enable it to remain agile when you perform steps on the data in the ...

Hi Dieneba, Without a mock-up example of the final output you'd like to see, I can't give you step by step. e.g. in that file there are subtotals, ...

Probably best, however if your query doesn't interact with external sources, like web pages, then the privacy settings aren't doing anything.

Hi Dieneba, The benefit of using Power Query over Excel is that it records the steps so you can automate the process and the next time you need to ...

Hi Mohamed, Your file didn't get attached. You need to click the 'start upload' button after selecting your file and then wait for the grey check m...

Hi David, I don't know of a way you can do this, however if the issue is that you don't want to see zeros in your spreadsheet, then you could use a...

This is ok for small tables, but I wouldn't do that on tables with upwards of hundreds of thousands of rows.

Hi Yuan, There's no built in way to do this, but this VBA code will list all PivotTables and their fields, so you can see which field name isn't me...

Hi Sari, This is a common locale issue. i.e. you've opened the file in a different locale to the one it was created for. You can use Power Query to...

Hi Stacy, Welcome to our forum! I'm not familiar with any Visio books or resources I could recommend, sorry. Perhaps someone else here knows more a...

Hi Susan, When you write a measure in a table as an added column there is no need to explicitly qualify the table name since this is implied. What ...

Hi Genevieve, I'm not sure what you mean by "all the months which don't start with the same three letters cause problems". Can you please share the...