Formula Help...Easy One.
 

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

--
vicprezwa
-----------------------------------------------------------------------
vicprezwak's Profile: http://www.officehelp.in/member.php?userid=494
View this thread: http://www.officehelp.in/showthread.php?t=125074

Posted from - http://www.officehelp.i

Formula Help...Easy One.
 

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 wrote:
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 chart
below to give a four for whatever player has the most points, 3 for the
next best player etc..

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

Formula Help...Easy One.
 

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 wrote:
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 chart
below to give a four for whatever player has the most points, 3 for the
next best player etc..

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

Formula Help...Easy One.
 

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

--
vicprezwa
-----------------------------------------------------------------------
vicprezwak's Profile: http://www.officehelp.in/member.php?userid=494
View this thread: http://www.officehelp.in/showthread.php?t=125074

Posted from - http://www.officehelp.i

Formula Help...Easy One.
 

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


--


Gary


"vicprezwak" wrote in message
...

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


--
vicprezwak
------------------------------------------------------------------------
vicprezwak's Profile: http://www.officehelp.in/member.php?userid=4944
View this thread: http://www.officehelp.in/showthread.php?t=1250744

Posted from - http://www.officehelp.in

Formula Help...Easy One.
 

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!

--
vicprezwa
-----------------------------------------------------------------------
vicprezwak's Profile: http://www.officehelp.in/member.php?userid=494
View this thread: http://www.officehelp.in/showthread.php?t=125074

Posted from - http://www.officehelp.i