Need help on macro to do ranking
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 |
Need help on macro to do ranking
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.
|
All times are GMT +1. The time now is 11:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com