returning absolute cell refs

[karl41]

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

[Naveen]

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
>
>

[Muhammed Rafeek M]

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
>
>

[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


"karl41" <[email protected]> wrote in
message news:[email protected]:

> 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