I have been at this for a little while now because I really wanted to figure it out on my own but after using match, max, and large the closest I got is the highest value and then another value duplicated which I don't understand how it picked it. I am trying to do a formula that will list the 3 highest values in column U for each set (row) listed by the header in row 34. Cell U36 is a proper example.
The example is a copy of the sheet where the info is. All the dollar values are actually formulas in the original sheet if that makes a difference.
Bookmarks