Need help on macro to do ranking

[ixara]

Dear all,

I want to do ranking by comparing value in each rows in columnB(Score)
The ranking will appear in columnC(Rank).But i don't know how to develo
a macro to do this. Sample data is as follows. Thanks in advance for an
help.

Original data:
Name Score Rank
ComA 15
ComB 44
ComC 5
ComD 21
ComE 10

Expected output:
Name Score Rank
ComA 15 3
ComB 44 5
ComC 5 1
ComD 21 4
ComE 10

 

[Claus Busch]

Hi,

Am Fri, 23 Nov 2012 12:00:11 +0000 schrieb ixara:

Original data:
Name Score Rank
ComA 15
ComB 44
ComC 5
ComD 21
ComE 10

Expected output:
Name Score Rank
ComA 15 3
ComB 44 5
ComC 5 1
ComD 21 4
ComE 10 2

in C2 try:
=RANK(B2,$B$2:$B$6,1)
and copy down


Regards
Claus Busch

 

[ixara]

Thanks so much. It works