On Mar 5, 3:23*pm, Lars-Åke Aspelin wrote:
On Thu, 5 Mar 2009 12:09:11 -0800 (PST), Opal
wrote:

I have been searching for hours with no resolution...

I need to find the cell location, not the value, of the maximum value
in a range. *I am using Excel 2003.

I have tried:

=MATCH(MAX(B9:AK9),B9:AK9)

and the result I get is 15
doesn't help me...the location I need is N9

can anyone help?

Try this formula:

=ADDRESS(ROW(B9),COLUMN(B9)+MATCH(MAX(B9:AK9),B9:A K9,0)-1,4)

Hope this helps / Lars-Åke

Thank you, Lars-Ake...it works....

Now, How can I point to the same column location but row 6 to get my
column heading?