| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference to a cell returned by MIN...how?
Well, my range is a non-contiguous space, like R18C2, R18C10, R37C2,
R37C10..how to go around about this constraint? Apparently MATCH does not like my range being scattered around... "Mike H" wrote: Hi, You could try:- =ADDRESS(MATCH(MIN(A1:A100),A1:A100,0),1) Where the range you are looking for the minimum in is A1 -A100 Mike "Mac" wrote: How do I get to the row and col reference of a cell whose value I obtain via calling MIN (I need to input this referece to OFFSET...) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula so if reference is selected, a specific value is returned. | Excel Worksheet Functions | |||
| Formula so if reference is selected, a specific value is returned | Excel Discussion (Misc queries) | |||
| limit characters returned a cell reference | Excel Worksheet Functions | |||
| Need reference in adjacent column returned | Excel Worksheet Functions | |||
| determine which cell a value is returned from | Excel Discussion (Misc queries) | |||
Threaded Mode
