How to remove repetitions (more than 3) in excel in excel?

Question

Visual Basic

There is a table in 50 000 records. in multiple columns. 1st and 2nd columns are id and date. Recording the arrival of customers for a certain number of years. How can I delete all customer records when they came more than 3 times? Someone came 1 time, someone 10. It is necessary that all the records of those who came 3 or less than 3 remain. But delete everything else.
To make it more clear, I'll show you with an example:-

-->

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

Answer 1

You have already asked this question.
How to do certain manipulations in Excel 2007?