Last seen: Jun 18, 2026
Hi Connie, You have two options: 1. Divide the total budget amount over the individual product items so the total of all items correctly adds up...
Hi Carlos, Thanks for clarifying. You can use Power Query to remove the duplicates, then you can use a PivotTable to summarise the counts. See file...
And the answer to my other question above: "Also, please clarify what you consider a duplicate. If we take the example of Nuno Nogueira who has 6 entr...
Purfleet is right. The data needs unpivoting. Please supply a sample file and mock-up of the layout you'd like in your report so we can help you furth...
Well done, Valouria! I had no idea what Saliha wanted. In future, Saliha, please provide an example. Even one line showing how you wanted the data ...
That file is exactly the same as the original file you uploaded. Neither of these files have an example of what you're expecting to see, so we cannot ...
I didn't think the red highlighted zero values were the issue. I thought the issue is the error messages you're getting. We can't replicate those, so ...
Hi Joseph, Refreshed fine for me. I had one zero value in the count (column D) highlighted in red, which was for RUS Dinamo Riga Mynda
Hi Carlos, What version of Excel do you have? Also, please clarify what you consider a duplicate. If we take the example of Nuno Nogueira who ha...
I'd be inclined to not load the first query's data to a table. Instead, link the other two queries directly to the first query. This will remove the n...
Hi Andrew, Those are waffle charts. You can replicate them in Excel using conditional formatting in cells. I haven't written about them yet (it's n...
Ooh, good idea, Velouria! Although, like you say, not relevant in this case, but crafty workaround to keep in mind for other scenarios.
Hi Julian, This cell returns: 0.000000000000002 Excel thinks it's being helpful by displaying it in scientific notation because it's such a tiny...
Hi Craig, Great to hear you're enjoying the course and finding it helpful! In regards to your two queries, are these loading data from a Table i...
Please provide an example based on your sample file of what you're describing because I can't picture what you mean, sorry.
