Challenges: Final Friday Fix: January 2021 Challenge
29 January 2021
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 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!
Happy First Final Friday Fix of 2021! Our first challenge of the year is to generate the list of the most recent items in a list simply using Excel formulae.
The Challenge
There is an Order_Database data set which contains details of Customer Name, Order Date and Order Volume over the time as shown below.
To facilitate the conversation with customers upon placing an order, the operator wants to view the five most recent orders from a given customer. Specifically, when a customer is selected from the list in cell F140 (see image below), their last five order dates will appear in cells F146:F150 in descending order, together with the related order volumes.
Can you get the list in cells F146:F150 in just two steps?
To make it easier for you, we have prepared a start file here so that you may have a play.
Sounds easy? Then why not have a go? We’ll publish one solution in Monday’s blog. Have a great weekend in the meantime!
