Return Column Headers based on row rank with duplicate values in row

Hi,

I need a means of ranking the highest 10 numbers in a row with duplicates where the value returned is not a rank order but rather a rank of the column titles corresponding to the rank of the row value.

Index match formulas like: =INDEX($B$1:$T2,1,MATCH(LARGE($B2:$T2,1),$B2:T2,0)) don't do the job because they return the first column title for each duplicate value, rather than the actual column title of each duplicate value.

Please find an example spreadsheet attached.

Many thanks,
Carl.

Hi

Please click on Attachment.
Doe that do the Job?

hi Carl, welcome to the forum. this seems pretty tough. try this array formula in V2 to copy down & across:

Formula:

Please Login or Register  to view this content.

you have to paste the formula inside the formula bar & press CTRL + SHIFT + ENTER. When done correctly, you should see curly brackets surrounding it