If you’ve ever struggled to make an Excel sheet that amazes users, this is the post for you.
In this post we will learn how to create a report that allows the user to query a list and return the top salaries for a set number of users along with those user’s Department(s) and Name(s).
What makes this so impressive is that you will allow the user to define how many records are returned, such as the Top 5, Top 10, or any number (within reason) that they choose. The function will even account for duplicate Top N salaries.
This will be accomplished using the new Dynamic Array FILTER function along with a little help from some other function to make things more interesting, such as multi-level sorting and dynamic numbering.