Remove accumulative data

Occasional Visitor

I have a large data set consisting of accumulative data. Some data contain same Customer ID however the customer bought different things. How do i filter duplicates to have only 1 data for each customer for each specific item ?

2 Replies



Maybe like this. The formula returns unique customer ids and items in columns D and E.

unique customer.JPGIf you work with Office365 or 2021 you can apply FILTER function. 


There is a special command for this in the Data section of the menu: "Remove Duplicates".