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