ranking numbers in a column

[Darryl]

I have 100 (100 rows) with different numbers all in one column. I have
ranked them in another column by largest to smallest in the past. The 100
numbers change from time to time. I would like the rankings to automatically
update. I wish not to sort. Is there a formula?

Thanks, Darryl

 

[trip_to_tokyo]

Try the RANK Function.

If my comments have helped please hit Yes.

Thanks.

 

[Gary''s Student]

Will there be "ties" in the data? That is, duplicate values?

 

[trip_to_tokyo]

1. Assume your data is in the range:-

C 2 to C 18

2. In cell E 2 (for example) type:-

=RANK(C2,C2:C18)

3. Copy the above formula from:-

E 3 to E 18 inclusive.

Your data is now ranked accordingly.

Please hit Yes if my comments have helped.

Thanks.

 

[trip_to_tokyo]

Sorry, range should be fixed so:-

=RANK(C2,$C$2:$C$18)

Apologies.

 

[trip_to_tokyo]

I have just put up my example for you at:-

http://www.pierrefondes.com/

Item number 39 towards the top of the page.

Please hit Yes if my comments have helped.

Thanks.

 

[Bernd P]

Hello,

I suggest not to use Rank but Countif:
http://sulprobil.com/html/rank.html

Regards,
Bernd

 

[Darryl]

Yes, there will be "ties". Thanks.

Will there be "ties" in the data? That is, duplicate values?