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 wrote in message
...
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.