One play, in say, C1:
=IF(ISNA(MATCH(MAX($A$1:$B$55,1),$A$1:$A$55,0)),IF (ISNA(MATCH(MAX($A$1:$B$55,1),$B$1:$B$55,0)),"","B "&MATCH(MAX($A$1:$B$55,1),$B$1:$B$55,0)),"A"&MATCH (MAX($A$1:$B$55,1),$A$1:$A$55,0))

The above sequentially matches the result from the MAX down col A first,
then down col B. If there are any ties in the MAX, then only the 1st matched
instance will be returned.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
---
"marc" wrote:
> 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