I need a way to list the top 10 aged items in a table. However, this need to be conditional on selected criteria (e.g. Top ten aged items for Location X and Business Unit Y for the Dates A-B)
I do this currently using a Query to the table, using a statement, more or less, like this:
However, some users are getting errors when the above query tries to refresh (I think it is related to network mapping, but I am not sure. My users are scattered over the globe and who knows what environments they have). So, I am trying to accomplish the same using strictly formulas.
I can get the Ages in descending order using this array formula,
But I don't know how to get the corresponding row numbers for the ages. I want to be able to list out some other columns that correspond to the highest Aged items.
Please see the attached file for more detail on what I am trying to accomplish.