display the cell that produced a result

Is there any way in Excel to display, or get, the cell that produced a
result. I am using the LARGE command to find the largest value in an array.
I then need to know which cell it came from. Is there any way of obtaining
that and displaying it somewhere?

Thanks for the help.

By cell you mean cell reference like A1,B14 etc then use this

=ADDRESS(MATCH(LARGE(A1:A100,1),A1:A100,0),COLUMN(A1:A100),4)
where a1:a100 is the range where you are seeking the largest value out of.
In case of a tie between 2 or more large values it will display the cell
reference of the first




"Jerry Wood" <Jerry [email protected]> wrote in message
news:[email protected]...
> Is there any way in Excel to display, or get, the cell that produced a
> result. I am using the LARGE command to find the largest value in an
> array.
> I then need to know which cell it came from. Is there any way of
> obtaining
> that and displaying it somewhere?
>
> Thanks for the help.
>