Please note javascript is required for full website functionality.
MVP

Blog

Final Friday Fix: February 2020 Challenge

28 February 2020

On the final Friday of each month, we’re going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel / Power BI fix”.  Challenge your office colleagues to see who can solve the puzzle quickest.  There are no prizes at this stage: you’re playing for bragging rights only!

 

This month’s Final Friday Fix involves the automation of grouping the rows according to different level of headings.  In financial modelling, grouping the rows for each worksheet based on the headings is a time-consuming process, it is especially the case for some financial models that have multiple worksheets.  In our challenge for this month, we have a worksheet with three (3) different levels of headings as shown below.

and after grouping at each different level, the result would be as follows.

First level:

Second level:

Third level:

We want to automate this process without manually grouping each heading.  Sounds like a job for VBA this month…

 

Sounds easy?  Then why not have a go?  We’ll publish one solution in Monday’s blog.  Have a great weekend in the meantime!

Newsletter