X
xxxMarkxxx
Original Question:
I need a function fo r the following:
In a given row of # values, I want to find the max. value and give the
associated text column heading in a new column. How do I do this??
Thanks
Original Answer:
With your headings in A1:Z1 and your numbers in A2:Z2
=INDEX(A1:Z1,MATCH(MAX(A2:Z2),A2:Z2),0)
This worked, but how can I reference more than one column heading
should there be multiple cells that equal the max value?
Thanks
I need a function fo r the following:
In a given row of # values, I want to find the max. value and give the
associated text column heading in a new column. How do I do this??
Thanks
Original Answer:
With your headings in A1:Z1 and your numbers in A2:Z2
=INDEX(A1:Z1,MATCH(MAX(A2:Z2),A2:Z2),0)
This worked, but how can I reference more than one column heading
should there be multiple cells that equal the max value?
Thanks