I have a list of ID numbers and I want to see the duplicates and delete all
the other records.

I have tried the Advanced Filter and it does not filter the list...

I know that it can't be too difficult to filter out.