If you have

=MAX(A2:E2) in F2 then

=INDEX(A$1:E$1,MATCH(F2,A2:E2,0))

copy down column

although where you have more than one Max value in a row, e.g. row
three, this formula will just give you the header relating to the first
match


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=505534