Prev: An odd question about formatting
Next: Dynamic Charts - working across multiple Worksheets
From: Darryl on 18 Jan 2010 12:59
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
From: trip_to_tokyo on 18 Jan 2010 13:12
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
From: Gary''s Student on 18 Jan 2010 13:14
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
From: trip_to_tokyo on 18 Jan 2010 13:21

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
From: trip_to_tokyo on 18 Jan 2010 13:32
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
 |  Next  |  Last
Pages: 1 2
Prev: An odd question about formatting
Next: Dynamic Charts - working across multiple Worksheets