YTLE#98: Excel ADDRESS function

[danmackellar]

I have a column of hundreds of numbers and I need to know the address of the minimum of those numbers. How would I do this?

Thanks

[ExcelIsFun]

Something like this may work:

=ADDRESS(MATCH(MIN(A1:A11),A1:­A11,0),1,4)

where 1) the values are in the range A1:A11, 2) if there are duplicates it will only find the first.

[soccerstarmikew]

Can you use an address in a range? A1: Address(....)

[ExcelIsFun]

Yes, the formula:

=ADDRESS(ROW(A1),COLUMN(A1),4)­&":"&ADDRESS(ROW(D1),COLUMN(D1­),4)

will deliver:

A1:D1