View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
madpeyjag madpeyjag is offline
external usenet poster
 
Posts: 3
Default search/delete duplicate entries in excel '02?

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?

"Gary Brown" wrote:

Find...replace with ""
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"madpeyjag" wrote:

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?