To handle ties it's more complicated. Basically, you have to coerce all the
numbers to be unique.

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=INDEX(A$1:F$1,MATCH(LARGE(A$2:F$2-COLUMN(A2:F2)/10^10,ROWS($1:1)),A$2:F$2-COLUMN(A$2:F$2)/10^10,0))

Copied down

Note: when there are ties the leftmost tie will be returned first.

Biff

"Jshendel" wrote in message
...
I have a list like this:
A B C D E F etc.
1 ab cd ef gh ij kl
2 8 1 4 2 5 3
3 1 3 9 5 8 2
etc.

For row 2, I want to find the max number and return the column header
(ab).
Then, another equation to find the 2nd highest value and return the column
header (ij), etc.

How do I do that?