Final Friday Fix: March 2025 Challenge
28 March 2025
On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.
The Challenge
This month’s Final Friday Fix is a reversal of last month’s problem: this time, you are challenged to condense individual sets of values into a categorisation table with divisions A, B and C. As an example:
A table (top) is provided, containing group classifications (A, B and C) and a corresponding value. A successful completion (bottom) will constitute proper categorisation (A, B and C) of these values with their appropriate alphanumeric form.
Why is this important? Because condensing data for effective storage, analysis and forecasting is often required by management in business. This month’s challenge will help you pick up this versatile skill so you may use it for all your data condensing needs, or maybe you’d just like to do it for fun!
You can download the original question file here.
Guidelines to get the most out of this challenge:
- the formula needs to be in just one cell (no “helper” cells)
- this is a formula challenge; no Power Query / Get & Transform or VBA!
Sounds easy? Then why not have a go? We’ll publish one solution in Monday’s blog. Have a great weekend in the meantime!
