Hi Totti,

Am Sun, 16 Oct 2011 06:16:55 -0700 (PDT) schrieb Totti:

Not really 100% but any other value may apply, just because the
progress is entered by a Data Entry Operator is by chance 100% but it
can range anywhere from 0 to 100

Description in Col A, actual % in Col B, weight/desc in Col C.
Sort by Col A and then in D2:
=IF(A2=A3,"",SUMPRODUCT(--($A$2:$A$100=A2),$B$2:$B$100,$C$2:$C$100))
and drag down.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2