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