| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I return the cell location
How do I return the cell location (in addition to the value contained in the
cell) of the maximum value in an Excel array? I'm trying to locate the row number for the maximum value in a column of numbers. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I return the cell location
Try:-
=ADDRESS(MIN(IF((A1:B4)=MAX(A1:B4),ROW(A1:B4),"")) ,COLUMN(A1:B4)) alter the array address as required. It's an array formula so enter with ctrl+shift+enter Mike "aneuro" wrote: How do I return the cell location (in addition to the value contained in the cell) of the maximum value in an Excel array? I'm trying to locate the row number for the maximum value in a column of numbers. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I return the cell location
=ADDRESS(MIN(IF((A1:A4)=MAX(A1:A4),ROW(A1:A4),"")) ,COLUMN(A1:A4)) excuse my typo "aneuro" wrote: How do I return the cell location (in addition to the value contained in the cell) of the maximum value in an Excel array? I'm trying to locate the row number for the maximum value in a column of numbers. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I return the cell location
Hi
To just return the row number in say column A, then MATCH(MAX(A:A),A:A,0) To get the cell Address =ADDRESS(MATCH(MAX(A:A),A:A,0),1) where the 1 refers to column A. Adjust accordingly if you change column letter. -- Regards Roger Govier "aneuro" wrote in message ... How do I return the cell location (in addition to the value contained in the cell) of the maximum value in an Excel array? I'm trying to locate the row number for the maximum value in a column of numbers. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I return the cell location
"Roger Govier" wrote: Hi To just return the row number in say column A, then MATCH(MAX(A:A),A:A,0) To get the cell Address =ADDRESS(MATCH(MAX(A:A),A:A,0),1) where the 1 refers to column A. Adjust accordingly if you change column letter. -- Regards Roger Govier Thank you very much my friend!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I return tthe location (cell) when using the max function | Excel Discussion (Misc queries) | |||
| Return the Row of a Variable's location | Excel Discussion (Misc queries) | |||
| Hyperlink or Other Method To Return To Previous Location (Sheet) Possible? | New Users to Excel | |||
| How to return a specific data point from a large array if I don't know the exact location? | Excel Discussion (Misc queries) | |||
| Is there a function that will return info of the cursor location? | Excel Worksheet Functions | |||
Linear Mode
