Originally Posted by Glenn Kennedy 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"
There are currently 1 users browsing this thread. (0 members and 1 guests)
View Tag Cloud
Forum Rules
Bookmarks