Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET | Excel Discussion (Misc queries) | |||
Return names which are repeated 5 times | Excel Discussion (Misc queries) | |||
How to change the size of characters in Sheet 1, Sheet2, Sheet 3 | Excel Discussion (Misc queries) | |||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
List a group of repeated data from sheet1 to sheet2 but not repeat | New Users to Excel |