Add values from duplicate rows and delete duplicate

[jane204]

I have the below values and I want to create a macro to add the duplicates and delete it.

Apple=260
Orange=3
Banana=246
Apple=43
Mango=93
Banana=4
Melon=260
Grape=209

After I run the macro, i want the result to be in the same column with the data as below

Apple=303
Orange=3
Banana=250
Mango=93
Melon=260
Grape=209

Please help me on how to do it. Thanks in advance!

[dflak]

You probably don't need a macro to do this. Your data is organized so that a pivot table should be able to do what you want.

[José Augusto]

Hi
You can use a formula to do that but a pivot table is (I suppose) the better solution as dflak said.
Assuming your data in a table Products(Names, Qtys) the formula is

Please Login or Register  to view this content.

where J4 is the name of the product

See the file with both solution.

[deciog]

jane204

One more solution

Decio