|Subject:||Have a value be shown as the referneced cell|
|Date:||Tue, 22 Jul 2008|
I am running a formula =Max($a$1:$B$55,1) to find the largest number in a set
of data. The answer was found in cell A36.
The formula was fine but I was wondering if there is a formula that will
display the answer's cell location.
The value of A36 is 10.
With my formula =Max($a$1:$B$55,1) the answer is 10.
But I would need another formula to display A36 (or the cell's location)
The find function isn't working