convert repeated sheet 1 names to once in sheet2
 

i have a work sheet contained name with score, in that sheet names are
repeating scores also repeated but values are change( ex: a=10, b= 6, c= 2,
a= 18, b= 1, c= 8, a =1)
in the sheet 2 i want only once of the name with total value

what i do
plesase help me

convert repeated sheet 1 names to once in sheet2
 

Naanishiva -

It looks like you need a pivot table. Use the pivot table wizard to do this
- you will to select the data area of the worksheet including the column
titles (name, score), and then put the results in the second worksheet. Use
the Layout button in the wizard to put the name in the Rows section, and the
score in the data section (you don't need a column section). The default for
the score is sum, so you should be good with that.

--
Daryl S


"naanishiva" wrote:

i have a work sheet contained name with score, in that sheet names are
repeating scores also repeated but values are change( ex: a=10, b= 6, c= 2,
a= 18, b= 1, c= 8, a =1)
in the sheet 2 i want only once of the name with total value

what i do
plesase help me