Final Friday Fix: June 2022 Challenge
24 June 2022
On the final Friday of each month, we are going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you are playing for bragging rights only!
The issue this month may be common and useful for anyone who uses Excel to produce cumulative / running total reports frequently. You can download the question file here.
This month’s challenge is to write a formula on a new column of the provided table to calculate the running total of column Number regardless of whether the Excel Table (i.e.created using Insert -> Table or CTRL + T) is filtered or not. The result should look like the column Total generated on the right (below):
As always, there are some requirements:
- the formula needs to be within just the Total column (no “helper” cells)
- this is a formula challenge; no Power Query / Get & Transform or VBA!
- the formula still calculates the correct running total when the table is filtered.
Sounds easy? Then why not have a go? We’ll publish one solution in Monday’s blog. Have a great weekend in the meantime!