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

Try the RANK Function.

If my comments have helped please hit Yes.

Thanks.



"Darryl" wrote:

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

Will there be "ties" in the data? That is, duplicate values?
--
Gary''s Student - gsnu200909


"Darryl" wrote:

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

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.


"Darryl" wrote:

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

Sorry, range should be fixed so:-

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

Apologies.





"trip_to_tokyo" wrote:


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.


"Darryl" wrote:

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

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.



"Darryl" wrote:

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

Hello,

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

Regards,
Bernd

Yes, there will be "ties". Thanks.
"Gary''s Student" wrote:

Will there be "ties" in the data? That is, duplicate values?
--
Gary''s Student - gsnu200909


"Darryl" wrote:

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