If Developer tab in Microsoft Office is missing, you can add Developer tab in Word, Excel, etc. via Settings, Group Policy, Registry Editor.

Using Excel’s conditional formatting to highlight duplicates in a single column is one way to find them quickly, although there’s less motive to delete duplicates in this situation.