Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Finding a cell location
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Finding a cell location
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" wrote: 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Finding a cell location
Thank you very much - thus far it works well.
"Max" wrote: 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" wrote: 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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Finding a cell location
Good to hear. You're welcome
-- Max Singapore http://savefile.com/projects/236895 Downloads:23,500 Files:370 Subscribers:66 xdemechanik --- "Lucask" wrote in message ... Thank you very much - thus far it works well. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the Location within an Array | Excel Worksheet Functions | |||
Finding the location of what was summed | Excel Worksheet Functions | |||
Finding the location of MAX value in column | Excel Discussion (Misc queries) | |||
finding cell location | Excel Discussion (Misc queries) | |||
finding rightmost location of a character | Excel Worksheet Functions |