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