On Mar 5, 3:09*pm, 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?

Just a little more information...perhaps there is an easier way
to get to what I want. I have a pivot table that shows downtime
for equipment in the shop. I have it set up to show only the top
3 incidents per week. I need to create a chart from the data
and my boss does not want a pivot chart. In the chart I need
to show not only the data, but the column heading. When
a breakdown occurs, our maintenance group classifies the
problem among several different reason codes which vary by
piece of equipment. These are the column headings. I
thought that if I could put in a formula that tells me the
location of the maximum value in the table I could then
use that info to point me to the correct column heading
to reference on the chart.....?? :-S Any advice would
be appreciated.