Have a value be shown as the referneced cell

Giganews Newsgroups
Subject: Have a value be shown as the referneced cell
Posted by:  Marc
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

Replies