Returning row names for multiple largest values

[OneEyeAskew]

I have data organized like this:

Month	Value1	Value2	Value3	Value4	Value5
Jan	4	1	1	1	1
Feb	2	2	0	3	1
Mar	3	3	3	0	1
April	3	2	2	1	0

And I want to return a list of row names for the highest three values in any given column. So, the following results would generate:

Value1: Jan, Mar, April
Value2: Feb, Mar, April
Value3: Jan, Mar, April
Value4: Jan, Feb, April
Value5: Jan, Feb, Mar

As you can see by my results, order doesn't matter -- I just need the highest 3 values. In the event of a tie, it is okay to truncate the list.

[Kaper]

I think it could be easier to obtain by formulas if produced output would be sorted from highest to lowest (with possible truncating duplicated lowest values).
But trying to obtain exactly what you've shown as a sample result would probably not be so easy. So I wrote a short VBA code to do it.

Please Login or Register  to view this content.

See sample file

[OneEyeAskew]

Hi Kaper, thank you so much for your help, and for the tips on attaching sample data. This solution works perfectly.

[ChemistB]

Not sure what works on MAC 16.4 but this formula works for me

Please Login or Register  to view this content.

with the data in B2:F5 and the formula in J8 copied down. If there are ties for 3rd place, it will give all results.

[OneEyeAskew]

Thank you both for these great solutions!