Forum Discussion
Remove accumulative data
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
There is a special command for this in the Data section of the menu: "Remove Duplicates".
=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.
