You could use Conditional Formatting to identify those entries that have 5 (or more). You say that you have 200 columns and 5000 rows. This can be adjusted to accommodate your data.
Select the data and enter the following formula in Conditional Formatting, New, Use Formula...
Formula:
=COUNTIF($A$1:$J$16,A1)=5
This will highlight all entries with the formatting that you choose that have 5 entries, you can delete the rest.
I used red to show the items to keep and have added filters that you can use to sort by colour.
Bookmarks