Hello!
I am looking to find the name of the product that has the highest value, second highest value, third highest, etc. all the way to top 20.
I have hundreds of columns and hundreds of rows, but for each row, I want to find the top 20 among the columns. (See attached excel for what I am looking to do).
I think this has something to do with the large function and a match, but am not exactly sure how to do it!
Thank you!
Sarra
Bookmarks