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

@Brenda1993 

=IF(COUNTIFS($A$2:$A2,$A2,$B$2:$B2,$B2)=1,A2,"")

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. 

@Brenda1993 

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

 

dscheikey_0-1662806236814.png