Macro to delete duplicate entries
 

Column A has 1000 rows of entries, some are duplicates.
How can I set up a Macro to delete duplicate entries.

Thanks in advance!
Ray

Macro to delete duplicate entries
 

Use the Advanced filter and select the uniques check box in the dialog.

Data=Filter=Advanced filter

--
Regards,
Tom Ogilvy

"Ray" wrote in message
...
Column A has 1000 rows of entries, some are duplicates.
How can I set up a Macro to delete duplicate entries.

Thanks in advance!
Ray

Macro to delete duplicate entries
 

Column A has 1000 rows of entries, some are duplicates.
How can I set up a Macro to delete duplicate entries.

Hi Ray, just do a search of this ng archives.. you should find what
you need...

seeya ste