Quote Originally Posted by Glenn Kennedy View Post
But does it work for Row 8??

An alternative:
=IFERROR(INDEX($A$1:$K$1,MATCH(MAX(A2:K2),A2:K2,0)),"")
i think the OP wanted a dynamic array which "doesn't require to be copied down through the column"