Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return the column
Hi Group,
I am looking for a formula that will return the column of a min and max formula. I am looking across row 38 with two formulas to find both a min and a max value, no problem. But I would like to return the columns of min and max locations. The formula far the max is =MAX(I38:T38,W38:AH38,AK38:AV38) and returns a value, but I want the column of the location of that max value returned. Thanks, -- David |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return the column
Hi Davis,
=MATCH(MAX(I38:T38,W38:AH38,AK38:AV38),38:38,0) -- Kind regards, Niek Otten Microsoft MVP - Excel "David" wrote in message ... | Hi Group, | | I am looking for a formula that will return the column of a min and max | formula. I am looking across row 38 with two formulas to find both a min and | a max value, no problem. But I would like to return the columns of min and | max locations. The formula far the max is =MAX(I38:T38,W38:AH38,AK38:AV38) | and returns a value, but I want the column of the location of that max value | returned. | | Thanks, | -- | David |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return the column
If you meant the column *number*, rather than the column as you posted,
then Niek Otten has supplied a formula. Alan Beban David wrote: Hi Group, I am looking for a formula that will return the column of a min and max formula. I am looking across row 38 with two formulas to find both a min and a max value, no problem. But I would like to return the columns of min and max locations. The formula far the max is =MAX(I38:T38,W38:AH38,AK38:AV38) and returns a value, but I want the column of the location of that max value returned. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return the column name using if function. | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions |