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
---