ok i think is would work but this was more than I expected. How would it work
if this was my actual data range.

$C$33 : $R$33 and I am finding the MIN

"Max" wrote:

> 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