Hi Nad,
Assuming the range of Names are in column A and scores are in column B
then the following formula in column C will return the names but only
in the first row that they appear eg AB in row 2 but not again in rows
4 or 7...

=IF(COUNTIF(A$2:A$65536,A2)-COUNTIF(A2:A$65536,A2)=0,A2,"")

There total scores can be returned in column D using...

=IF(C2<"",SUMPRODUCT(($A$2:$A$65536=A2)*$B$2:$B$6 5536),"")

You can then apply auto filter to hide the blank rows then copy and
paste to wherever.

Ken Johnson