# rank formula

[cyndi]

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

 

[Dave F]

=max(A1:A5) etc.

Dave

 

[cyndi]

Thanks, but the formula will only tell what the max number is, My company may
rank 3rd out of all the companies, and taht is waht I need, I will not
always be the maxium number. Hoope this makes sense

 

[cyndi]

Thanks, but the =max formula will not work, my company may not always be top,
whe may be 3rd, or 6th rank, so I need to take my company and see what rank I
am compared to the other companes. Hope this makes sense

 

[Gary''s Student]

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.

 

[cyndi]

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

 

[Dave F]

Rather than tell us you don't understand post the formula that is not working
for you, as we can't read your mind.

Then perhaps we could understand what you're doing wrong and help you fix it.

See also this explanation of the RANK function:
http://www.techonthenet.com/excel/formulas/rank.php

Dave

 

[Gary''s Student]

I understand now. Let's say your company is in column E and its number is in
E2. Its rank will be:

=RANK(E2,2:2,0)

A value of 1 means its in first place, etc.

 

[cyndi]

umm thanks for all your help, but I got the =rank(i2,i2:j2) to work for me

 

[cyndi]

yes, thanks that is what I was looking for.

Dave for your response, I understand you are not mind readers, i wasn't
asking for help on the rank functions, becasue I was already confusing you as
it was.

I am all set, thanks again, and I will post this as helpful