Hi,
a modification of Bernie Deitrick code:

G2: =1000*SUM(A2:E2)+100*SUM(C2:E2)+10*SUM(D2:E2)+E2
H2: =RANK(G2,$G$2:$G$4,0)

Adjust $G$2:$G$4 in RANK(G2,$G$2:$G$4) to match your data range, the
copy down.

Jare

--
Jare
-----------------------------------------------------------------------
Jarek's Profile: http://www.excelforum.com/member.php...info&userid=96
View this thread: http://www.excelforum.com/showthread.php?threadid=27691