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 develop a macro to do this. Sample data is as follows. Thanks in advance for any 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 2

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thanks so much. It works.