Not precisely what you asked for, but a nice display of the data would be to
alphabetize on the name column, then do Data Subtotals At each change in
: NAME Use function: SUM Add subtotal to: check the SCORE box OK

Vaya con Dios,
Chuck, CABGx3


"Nad" wrote in message
...
i have the following data
Name Score
AB 10
CD 15
AB 05
EF 20
CD 30
AB 50
I want to dispaly only the unique records with their total score.(e.g. AB
65)
Pls help, i am trying since last three days.