PLACINGS FROM HIGH TO LOW

[SO CONFUSED]

I am using Excel 2003. I know a bit outdated but oh well. My challenge to
anyone is this:

I want the table to display the following information:
answer is: A Colum 500 therefore came in B Colum 1st Place
A Colum 450 therefore came in B Colum 2nd Place
A Colum 400 therefore came in B Colum 3rd Place
and continue this on for many answers that I have with the placings.
Should sound easy but i do not know what function i should use. Please help
the so confused novice. I do not have any books on excel so could not look
this info up.

 

[Max]

Try RANK. Assume source numbers in A2:A10
Place this in B2: =RANK(A2,A$2:A$10)
Copy down to B10

.. using Excel 2003. I know a bit outdated ..

Other than the no. of rows/cols, not really, IMO.
I'm using xl2003 since 2006, and its adequate.
(Before that I was using xl97 right till 2006)

Heard that xl2007 has over 16k cols and 1 million rows per sheet
compared to xl2003's "puny" 256 cols x 65k rows
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---

 

[Dave Curtis]

Try =RANK(A1,$A$1:$A$3) or whatever range you need. This will put a 1,2,3,
etc in column B.

If you really need it to give an ordinal followed by the word "Place", use

=B1&IF(OR(RIGHT(B1,2)="11",RIGHT(B1,2)="12",RIGHT(B1,2)="13",MOD(B1,10)=0,
MOD(B1,10)>=4),"th",CHOOSE(RIGHT(B1,1),"st","nd","rd"))&" Place"

in C1 and copy down, which will give you 1st, 2nd 3rd Place etc.

You could combine the two by burying the RANK formula inside the second one
seven times, but you'd be better of just hiding column B.

Dave

url:http://www.ureader.com/msg/104241602.aspx