Macro to delete duplicate entries

R

Ray

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
 
T

Tom Ogilvy

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

Data=>Filter=>Advanced filter
 
S

ste mac

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

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

seeya ste
 
Top