Deleting Duplicates in spreadsheet

K

Kathy

I have about 2,500 records, and want to delete any duplicates there may be. I tried filtering, but it did not help. Any suggestions?
 
A

Andy Brown

If you're not comfy with code, you could try Advanced Filter.

Probably best to filter the unique ones to a new sheet. Click on eg: Sheet2
A1, then Data -- Filter -- Advanced Filter. Go back to the main sheet and
select the range so that this shows up in List Range. Action = copy to
another location, this should jump you back to Sheet2 A1. Click in Copy To,
click on A1. Check Unique Records Only, click OK.

Rgds,
Andy
 

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

I have lost 6 months work, how can i get my file back 1
Repeated phrases wildcard? 1
Delete rows that contain duplicates 1
Eliminate Duplicate Entries in Order to Create Labels Using Mail M 3
Section Breaks 0
Spreadsheet - Deleting Duplicate Records - Self Checking 1
Finding Duplicate Rows & Highlighting them 6
How to delete all duplicate records - without keeping one of them 5

Top