Find top 5 highest values in row from every third column and return column header

Hi there,

I suspect that my problem may be beyond the capabilities of a function (time to relearn some VBA?), but thought I'd see if anyone had any ideas!

I would like to find the top 3 (or any number) highest percentage values in a row, from every third column; then, copy the column headers to a new cell so I can see what the column titles are, in order, of the top 5 highest values.

Data looks like this:
A |B | C |D | E | F | G | H | I|
1 25 7% 25 25 6% 25 25 12%
2 25 8% 25 25 9% 25 25 17%


Want:
1 - "I" 12% "C" 7% "F" 6%
2 - "I" 17% "F" 9% "C" 8%


I have seen similar problems posted here and on the mr.excel forum using INDEX MATCH MATCH and LARGE - however, in all of those cases, the rows had consistent data, and didn't have to do something like only look at every third column.

Any suggestions? Anything is appreciated!

Cheers

P.S. Not sure how to get my example data properly aligned - the letters were supposed to be over each number. Sorry!

Dave, MarvinP - thank you both for the time you put in to this! A great help and much appreciated.

I have to admit though, I'm still working through how Dave's answer/syntax actually works. May come back if I can't get it.

There are very likely ties - I think I have something like 2000 columns. I guess I could always just increase the number of decimal points to decrease the likelihood of ties?

Thanks again!

Originally Posted by MarvinP

..... Your answer is better if he had spread out the columns he wanted to use. ....

Could you explain what you mean by this?