can excel calculate positions basing on values?

[marc2000]

Basing on the different values in a given column (say in column C), ca
Excel XP calculate the positions (1st, 2nd, 3rd…etc.) automatically i
corresponding cells of another column (say in column D)?

What will be the syntax? Please help!

 

[Frank Kabel]

Hi
try in D1
=RANK(C1,$C$1:$C$100)
and copy down

 

[Thrava]

doesn't the list ought to be sorted in either ascending or
descending order?

 

[JE McGimpsey]

No.

 

[Norman Harker]

Hi Thrava!

Try Frank's suggestion. The answer is, "No!"

RANK'S first argument specifies the cell to be ranked, the second
argument gives the listing as an absolute reference to facilitate
copying down. There is a third argument, order, where a non-zero entry
allows the ranking to be from the bottom up (as for golf scores etc
where lowest is highest).

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Dave Peterson]

Doesn't need to be. In fact, you may want to sort it by that column that has
the rank formula--to put it in nice order.

 

[marc2000]

Vielen dank Kabel! I would try your guidelines. Thanks again!