Finding a cell location

[Lucask]

I am trying to find the exact cell reference (or even column) that contains
the max of a range.
Basically, after I find the highest or lowest of a range, I want to be able
to identify which column it's in and then display that column heading in
another cell.

 

[Max]

Something like this will extract the col header within B1:E1
for the max within each row in row2 down
(that's the underlying functionality that you seek)

In F2: =INDEX($B$1:$E$1,MATCH(MAX(B2:E2),B2:E2,0))
Copy F2 down

If there are any ties in the maximum,
the expression returns the leftmost col header

High-five?, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik

 

[Lucask]

Thank you very much - thus far it works well.

Something like this will extract the col header within B1:E1
for the max within each row in row2 down
(that's the underlying functionality that you seek)

In F2: =INDEX($B$1:$E$1,MATCH(MAX(B2:E2),B2:E2,0))
Copy F2 down

If there are any ties in the maximum,
the expression returns the leftmost col header

High-five?, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik

 

[Max]

Good to hear. You're welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik