search/delete duplicate entries in excel '02?

[madpeyjag]

I have 3 columns and 2000+ rows of data. Is there a way to search and delete
duplicate entries for 1 or more of the columns?

 

[Gary Brown]

Find...replace with ""
--
HTH,
Gary Brown
[email protected]
If this post was helpful to you, please select ''YES'' at the bottom of the
post.

 

[madpeyjag]

I'm don't want to have to manually search for duplicate records. I want excel
to do it for me. If there are any duplicates I want it to delete one of them.
Cause I'm going to use it for a mail merge and I don't want to send anyone
more than one letter. Does that make sense?

 

[Debra Dalgleish]

You can use the techniques on Chip Pearson's site, to mark and delete
the duplicates in the source data:

http://www.cpearson.com/excel/duplicat.htm