returning absolute cell refs
 

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


--
karl41
------------------------------------------------------------------------
karl41's Profile: http://www.excelforum.com/member.php...o&userid=37473
View this thread: http://www.excelforum.com/showthread...hreadid=574107

returning absolute cell refs
 

Try this, you will get row number:

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

"karl41" wrote:


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


--
karl41
------------------------------------------------------------------------
karl41's Profile: http://www.excelforum.com/member.php...o&userid=37473
View this thread: http://www.excelforum.com/showthread...hreadid=574107

returning absolute cell refs
 

use ADDRESS function

"karl41" wrote:


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


--
karl41
------------------------------------------------------------------------
karl41's Profile: http://www.excelforum.com/member.php...o&userid=37473
View this thread: http://www.excelforum.com/showthread...hreadid=574107

returning absolute cell refs
 

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


"karl41" wrote in
message :

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


--
karl41
------------------------------------------------------------------------
karl41's Profile: http://www.excelforum.com/member.php...o&userid=37473
View this thread: http://www.excelforum.com/showthread...hreadid=574107