conditional sorting

C

cjrolls

Hello, Is there a way to rank certain cells according to their value. I have
something like this. I need a formula to enter in column B which will change
as the scores in column A change. Any help much appreciated.
A B
SCORE RANK
10 4
21 3
56 2
3 5
76 1
 
M

Mike

You had the correct word in Rank. Try this in B2 abd drag down.

=RANK(A2,A$2:A$6,0)

Mike
 
Top