Formula Help...Easy One.

[vicprezwak]

I cant remember how to formulate this.
I have the following data:

COLUM 1 COLUM
Player1 50 points
Player2 75 points
Player3 65 points
Player4 35 points

I want to take this chart and have a chart below it. I want the char
below to give a four for whatever player has the most points, 3 for th
next best player etc..

What would the excel forumla be for this? Thank you fory oru help

 

[Ken Puls]

Try the Rank formula

Assuming your data is in A1:B4, and you drop the "points" from the end,
enter the following in C1 and copy down

=Rank(B1,B$1:B$4)

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

 

[Ken Puls]

Try the Rank formula

Assuming your data is in A1:B4, and you drop the "points" from the end,
enter the following in C1 and copy down

=Rank(B1,B$1:B$4)

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

 

[vicprezwak]

That works great. Is it possible to make it so the person with the mos
points would rank 4th instead of 1st and so on

 

[Gary Keramidas]

RANK(number,ref,order)

Number is the number whose rank you want to find.

Ref is an array of, or a reference to, a list of numbers. Nonnumeric values
in ref are ignored.

Order is a number specifying how to rank number.

a.. If order is 0 (zero) or omitted, Microsoft Excel ranks number as if ref
were a list sorted in descending order.
b.. If order is any nonzero value, Microsoft Excel ranks number as if ref were
a list sorted in ascending order

 

[vicprezwak]

I think I got it. It took me a while to understand the order part.
didnt realize it was not in your first post. Thank you for hte hel
Gary!