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.