sum and remove duplicates

Hi,

Could anyone help to write a vba code to sum values in col c and remove duplicates in A B. but keep all data in A B C.

sd.png

In E2

Formula:

Please Login or Register  to view this content.

and in F2

Formula:

Please Login or Register  to view this content.

I would use a Pivot Table for this.

Highlight A1:C11 > Insert > Pivot Table > Choose where to put it > OK
Drag product under ROWS and qty under VALUES
Make sure qty is being summed. If it isn't you can click on qty under VALUES and select Value Field Settings > Sum > OK
You can choose to keep or remove the grand total at the bottom here: Design > Grand Totals > Off for Rows and Columns

See attachment.