Remove accumulative data

[Brenda1993]

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]

@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.

If you work with Office365 or 2021 you can apply FILTER function. 

[#3]

@Brenda1993 

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