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