returning absolute cell refs

[karl41]

I was looking through a column of data and wanted a formula which woul
return the cell reference, i tried CELL("row",min(A:A)) but thi
yeilded an error, help greatly appreciate

 

[Guest]

Try this, you will get row number:

=MATCH(MIN(A:A),A:A,0)

 

[Guest]

use ADDRESS function

 

[Jim May]

Enter the below formula in say B1:

=ADDRESS(MATCH((MIN(A:A)),A:A,0),1) ' the last 1 indicates Column 1 (A)

It will produce the address of the Smallest
Number you have in Column A

HTH