How delete duplicates (more 3 times) in excel?

(Ilja Magdenko) #1

50 000 entries. In a few columns. 1 and 2 columns are the ID and date. Recording the arrival of customers for a certain number of years. How can I delete all customer records when they have visited more than 3 times? Someone came 1 time, someone 10. It should be that all the records of those who came 3 or less 3 remains. But everything else - removed.

To make it more clear, I will show by example: -


As you can see, need to delete the entire line with the record of the visit more than 3 times. But leave those where you came 3 or less than 3 times.