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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solution to tricky problem of showing exactly Top N rows in Pivottable 0
return multiple values when within range (greater than and less than) 11
descending order of a series of data 8
Drop down list control value in vba 2
Need help on macro to do ranking 2
Rank order with conditions 3
Weighted ranking of a series 3
Ranking without skipping ranks and percentile 3

Top