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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to find the address of the min cell within a range (https://www.excelbanter.com/excel-worksheet-functions/143174-how-find-address-min-cell-within-range.html)

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

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

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

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?

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

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?