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.
|