sorry, I think you are misunderstanding what I need, I dont need the maxium
value of anything or the company name, I jsut need where I rank out of all
the companies, I found the rank formula =rank(), I can get it to work on
basic numbers but I am getting a N/a when I try it out on the worksheet I need

"Gary''s Student" wrote:

If your titles are in row 1 and the values are in row 2 then

=MAX(2:2) will return the maximum value in row 2 and

=OFFSET(1:1,0,MATCH(MAX(2:2),2:2,0)-1,1,1) will return the associated
company name.
--
Gary''s Student - gsnu200713


"cyndi" wrote:

Hello,
I am using excel 2003
I have a row of data of where each company ranks for sales, I want to be
able to see what number my company is based on ohter numbers for example

ESPN ESPN2 A&E Mundo CNN en Español CNN
168.6 238.4 256.7 108.0 626.2

Let say I work for CNN (which I do not) CNN would be rank number 1

Is there a formula for this? Instead of manually have to look at each row

Thanks so much