Help pls

S

shrutikhurana

Hi

I have an excel sheet with 2 columns...it something like this

a 2
a 1
b 4
b 3
b 1
c 0
d 5
d 7
d 1......

I wish to make a new worksheet which adds the 2nd column for each same
entry in the 1st column

so
a 3
b 8
c 0
d 8


is it possible?


Thanks in advance!!!!
 
G

Gary''s Student

If there are very few names, then use SUMIF.
If there are many names, use a pivot table.
 
S

shrutikhurana

Somebody pls guide me regarding how to use pivot table in this case to
get a final worksheet with no repetitive entries of column 1, and the
total of the repetitive entries in column 2 for each entry of column 1
 
V

via135

-select your source table
-Goto- Data>Subtotals>
"at each change in"-select>col"a"
"use function" - select>'sum"
-click"ok"

you will get your list!

-via135
 
Top