Another way:

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

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JE McGimpsey" wrote in message
...
one way:

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


In article ,
Will wrote:

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