cell reference?

X

xxxMarkxxx

I need a function fo r the following:

In a given row of # values, I want to find the max. value and give th
associated text column heading in a new column. How do I do this?
Thank
 
R

Roger Govier

Hi Mark

With your headings in A1:Z1 and your numbers in A2:Z2
=INDEX(A1:Z1,MATCH(MAX(A2:Z2),A2:Z2))

Regards

Roger Govier
 
Top