One I've tried multiple versions and scoured the internet for but cannot find the answer...
I'm trying to return the Top 5 Destinations our employees travel to, and present them on a dashboard based on dropdown lists for the Snr Exec to choose from.
So for example, they will choose the month, department, and then based on the highest total $ amount from a pivot table and these two criteria (or more) they will see the top 3 destinations.
I've attached a workbook that had my final desperation attempt in Column I, and the array formula as follows:
Col. C is the destination I would like returned, Col. A contains the month, Col. B the Department, and Col. D the amounts that I'm trying to find the Top 5 from largest to smallest to return the destination from Col. C.
Any help would be massively appreciated please