Forum

Hi Chris, The cause will be data or artifacts in the cells that you can't see. I suspect there are rows that contain non-printing characters or sim...

Hi Adam, You can use the Group By tool in Power Query to group the data based on the Country column. However, you said you have the dates going ...

Hi Jo, Welcome to our forum! Thanks for sharing your files. That data sure is messy! You need to get it into a tabular format with columns for e...

Yes, Power Pivot is a vast topic. If you're interested in getting your skills up to speed quickly, please consider my Power Pivot course.

Hi Chris, Please try using =Excel.CurrentWorkbook() to get all of the sheets in one go, as explained here: Let us know if you're still getting th...

Ah, glad you found it!

Thanks for sharing, Peter. Your approach is unique and works fine for one year of data, which might be all you need it for. Keep in mind that if yo...

Hi Adil, Welcome to our forum! I don't have any examples of this type of analysis, sorry. I'm sure there are many contributors to compare that coul...

Hi Eric, If you only have one dot per range then you can use a column/line chart combo with regular charts or Pivot Charts. If you need multiple po...

Hi Steven, If you have Excel 2013 or later you can add Slicers for Excel Tables and put the Slicer on any sheet i.e. it can go on the same sheet as...

Hi Aye, There is no built in way to do this. You can try searching for a custom visual that does what you want, or align the Sparkline custom visua...

Hi Sue, Great to see you're making progress. You can use IFERROR to hide #N/A errors e.g. =IFERROR(VLOOKUP(...),"") Mynda

Hi Peter, 70k rows is nothing for Power Pivot. I doubt it will even blink. Just make sure if you use formulas to apportion the budget over months tha...

Hi Stephen, I think this is a bug and have escalated it to Microsoft. In the meantime you can add your extra column or use Power Query to automate...

Hi Cam/Jim (not sure which name to use), Do you have an Office 365/Microsoft 365 licence? If so, you can use workbook co-authoring to allow both Su...