Hi Jarek!
Your assistance is very profesional,
thank you for helping!

Best Regards
Mark


-----Original Message-----

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, then
copy down.

Jarek


--
Jarek
----------------------------------------------------------
--------------
Jarek's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=965
View this thread:
http://www.excelforum.com/showthread...hreadid=276917

.