How to find the address of the min cell within a range

Will · May 17, 2007

Ihave a range A1:A10 and I need to know the Cell address that contains the
min value... any ideas?

JE McGimpsey · May 17, 2007

one way:

=CELL("address",INDEX(A1:A10,MATCH(MIN(A1:A10),A1:A10,FALSE)))

Ragdyer · May 17, 2007

Another way:

=ADDRESS(MATCH(MIN(A1:A10),A1:A10,0),1)