Forum Discussion
Return column header for max value excel but ...
Hi, I'm trying to return the column header for max value in excel. Formula using below at the moment: =INDEX($1:$1,1, MATCH(MAX(C5,AG5,AP5,AY5,BH5,BQ5,BZ5,CI5,CR5),(C5,AG5,AP5,AY5,BH5,BQ5,BZ5,CI5,...
I tried your formula with fewer cells but it works the same. If there is no other numeric data between the cells referenced, something like this will work:
=INDEX($1:$1,,MATCH(MAX(C5,AG5,AP5,AY5,BH5),$5:$5,0))