Comparing values and returning the column heading

  • Thread starter Thread starter Steven Brobst
  • Start date Start date
S

Steven Brobst

Is there a way to take the max value of a range of cells ( say a3:g3 ) and
return the row 1 value of that?

Like if max(a3:g3) would say the value of f3 is the largest, I would like
the cell to actually return the value (company name) of F1


Thanks,
Steven
 
=INDEX(A:G1,MATCH(MAX(A3:G3),A3:G3,0))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top