Final Friday Fix: September 2024 Challenge

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, we have another bold challenge that sounds simple but requires some thought.

Consider the following:

You can download the original question file here.  We have a list of accounting data, where some of the Account data is shown in bold case.  We need to filter the data so that only the rows with bold account codes are shown.

This month’s challenge is simple.  Solve it as simply as possible, with no Preview features, VBA or Power Query.  This is a deceptively simple Excel challenge!

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