Remove Duplicate records

[authorsami]

I have an Excel spreadsheet that I'm using as a Data Source for a Word Mail Merge. I have over 38,000 records. Some of these records are duplicate names and address. I'd live to find a way to remove the duplicates so that the names only appear once.

Any suggestions????

Sharon

 

[xlbo]

Define Duplicate

What columns need to be identical for it to be a duplicate ??

This has come up loads previously - have a search in th archives for delete duplicates and you should get lots of hits

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[taylo40]

Hi,

I have found the best way is to sort the data based on the column that has the duplicates. If you sort the data in assending order, all of similar values will appear next to each other.

Insert a column and type the following formula.

=If(A2=A1,"duplicate,"&quot
copy the formula down.
Copy the formula as paste special to turn it into a value.

You can now sort the data by the column you entered the formula.

All of the duplicates will appear together and you can delete these rows.

Hope this helps,

Jamie

 

[jfhewitt]

Use "unique records only" in advanced data filter.

 

[authorsami]

Thanks for the help.