Forum Discussion

Anatoliy1992

Copper Contributor

Feb 01, 2022

How to sum values and remove duplicates rows

Hi All, I'm trying to remove duplicates and sum values. I have table which is looks like that. item number client Date Quantity 167 C10000038 28/01/2022 00:00 3 600831 ...

Platinum Contributor

Feb 02, 2022

Anatoliy1992 Can't help you with the VBA code but perhaps you want to consider using Power Query in stead. See attached.

anatoliy.xlsx18 KB