Hi there,
I have a table with items "RESULT 1" to "RESULT 5". Each RESULT has a number in the next collumn.
I want to find the top 3 values from the list and return the Item name (RESULT x).
I have been able to do this successfully by merging a "Large" formula and getting the desired result with an "Index/Match" formula.
However, if there are identical numbers i the top 3 values, the formula only returns one of the matched values. I'd like a formula that finds the top 3 results, even if two of those numbers are the same.
It would be even better if it was an array formula and showed the top 4 results if, for example, there were two values coming back as third largest.
I have attached an Excel sheet for your reference. The red cells are the formulas and the desired results are in collumn F & L.
Thank you so much,
Danny
Bookmarks