| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to find the address of the min cell within a range
Ihave a range A1:A10 and I need to know the Cell address that contains the
min value... any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to find the address of the min cell within a range
one way:
=CELL("address",INDEX(A1:A10,MATCH(MIN(A1:A10),A1: A10,FALSE))) In article , Will wrote: Ihave a range A1:A10 and I need to know the Cell address that contains the min value... any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to find the address of the min cell within a range
Another way:
=ADDRESS(MATCH(MIN(A1:A10),A1:A10,0),1) -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "JE McGimpsey" wrote in message ... one way: =CELL("address",INDEX(A1:A10,MATCH(MIN(A1:A10),A1: A10,FALSE))) In article , Will wrote: Ihave a range A1:A10 and I need to know the Cell address that contains the min value... any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find address of cell containing maximum value | Excel Worksheet Functions | |||
| Find address of active cell | Excel Worksheet Functions | |||
| Is there a way to find the address of a cell with a certain value? | Excel Worksheet Functions | |||
| Function to find the address of a cell | Excel Worksheet Functions | |||
| How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
Hybrid Mode
