| Home |
| Search |
| Today's Posts |
|
#13
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to find the address of a cell
Ron Coderre wrote...
If you only want to use out-of -the-box Excel functions...try this: A1: (some range reference, like B1:L10) A2: =ADDRESS(SUMPRODUCT(--((INDIRECT(A1))=MIN(INDIRECT(A1))) *ROW(INDIRECT(A1))),SUMPRODUCT(--((INDIRECT(A1))=MIN(INDIRECT(A1))) *COLUMN(INDIRECT(A1)))) .... FWIW, this only works when there's a single instance of the minimum value. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| How do I obtain the address of a cell using the vlookup function? | Excel Worksheet Functions | |||
| Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
| Is there a function for "not isblank" (find a cell that has a val. | Excel Worksheet Functions | |||
Threaded Mode
