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