sum of duplicates

[zxmax]

Greeting all,
i have a sheet that has 2 colums, colum 1 has a product name , and colum 2 has quantanty
In colum 1 we have duplicates product name with different quantaty> so how do i Combine and sum duplicate (
eg:
product qty
hats 2
hats 5
boots 3
boots 1
----------------
want it to look like:
product qty
hats 7
boots 4


thanks in advance
i'm a rooky at this

 

[Barry Katcher]

Highlight your Product column (col. A in example), copy it to the clipboard, and paste it to A1 on a clean sheet. Then, choose Data>Filter>Advanced Filter.

In the dialogue box, tick the "Unique records only" option. This will filter the column in place for just unique values.

Copy this to the clipboard, return to your working sheet, and paste it wherever you want.

 

[zxmax]

wow, i got it working, thanks again barry