Macro to delete duplicate entries

  • Thread starter Thread starter Ray
  • Start date Start date
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
 
Use the Advanced filter and select the uniques check box in the dialog.

Data=>Filter=>Advanced filter
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

get Data Validation to stop, list supplied, duplicate data entries 1
Best solution to merge multiple Outlook contacts easily 2
Access Auto Matching Duplicates? 0
Pls help me in finding duplicate entries in a column range 2
Comparing Rows 9
Excel - Identify and delete duplicate rows 2
Delete Entire Row for duplicate values in selected column 2
Macro to Delete multiple/duplicated lines 2

Back
Top