I am trying to write a macro in excel, but I would like to do all this in access because I am taking this table from access pasting into excel and trying to delete duplicates by choosing the unique records. The trouble I am facing is that even when I advance filter for unique records, it does not delete all duplicates.
I have a table:
Date ID Facility
xxx xx xxx
I want to find any duplicates in the ID column then delete the entire row where the duplication is found. Can I do this?