# rank formula
 

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

# rank formula
 

=max(A1:A5) etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"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

# rank formula
 

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

"Dave F" wrote:

=max(A1:A5) etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"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

# rank formula
 

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

"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

# rank formula
 

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

# rank formula
 

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

# rank formula
 

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"cyndi" wrote:

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

# rank formula
 

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.
--
Gary''s Student - gsnu200713

# rank formula
 

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

"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

# rank formula
 

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

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200713