display the cell that produced a result

J

Jerry Wood

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

N Harkawat

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
 
Top