Remove Duplicates - similar but not exact

Hi all, I have data entered by multiple users, my table consists of time and plates. Ideally, each person suppose to enter a unique plate number/ take turns in entering the data, however I have instances where there will be the same plate entered within a 5 minute window. Thus, because the times are slightly off/ different, excel's "Remove duplicates" does not register these as duplicates due to the seconds/ minutes difference. How can I remove these duplicates within a 5 minute window?
I am no expert in coding, I just know basic excel formulas. An example of the repeated data and my desired outcome is highlighted in the attached.

Thank you in advance.

Attachment 766095

We can't tell what's going on from a screen shot. Please see "HOW TO ATTACH YOUR SAMPLE WORKBOOK" in the yellow banner at the top of the page and attach your actual file (it's easier to attach the Excel file than to take a screen shot and attach that).

You could try adding a helper column with this formula (assuming you show col A and B)...
=SUMPRODUCT(--(B1=$B$1:B1)--(COUNTIF(A1,$A$1:A1+(5/60/24))))

Then filter on the helper, it should show you all the duplicates - check a few to make sure it's working OK. You can then delete the 2's

Format your source as a table, then use a Power Query:

Please Login or Register  to view this content.