Match Var names with sorted coefs

You need to use a combination of EXCEL formulas:
LARGE - to find the Nth largest value
MATCH - to find the column in which it occurs
INDEX - to return the "heading" at the position given by MATCH

=INDEX($K$5:$Z$5,1,MATCH(LARGE($K6:$Z6,B$5),$K6:$Z6,0))

Select allOpen in new window

See attached file with results. I've put the required position in a row. You can hard code this as the second parameter to the LARGE function.

I have not done anything with the colours though. But conditional formatting will help.

This will help understand the real value of those formulas: https://www.deskbright.com/excel/using-index-match-match

No attachment ?

That's Brilliant, Thanks Mlanda

Regards

Ian