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

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

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

Mike


"cjrolls" wrote:

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

You guys are the best. Thankyou very much

"Mike" wrote:

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

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

Mike


"cjrolls" wrote:

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