Eliminate Duplicate Entries in Order to Create Labels Using Mail M

[Karen]

Using Excel 2003
I have a spreadsheet that has several hundred rows and 5 columns. I want to
do a mail merge and create labels with the records. The problem I’m having is
that there are many rows of data that are duplicates. FYI - If there is a
duplicate entry, all of the columns will be the same data, not just one
column.

First I went to Data > Filter > Advanced Filter > Filter the List, in-place

Unique Records Only. It then hid the rows with the duplicate data. When I

do a mail merge to create some labels, it includes my duplicate records
(hidden rows) and I don’t want that.

Is there a better way to do this? What I really need to do is delete the
duplicates and not just hide them. That way they will not be included in the

Does anyone have any suggestions?
Thanks, Karen

 

[Daryl S]

Karen -

With the records filtered to unique ones, copy the data and paste it into a
new worksheet. Then drive your mail merge off the new worksheet.

 

[Karen]

Thank You!
It worked like a charm!
Have a great day, Karen

 

[Ashish Mathur]

Hi,

Instead of "Filter the list in place", select "Copy to another location"

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com