Duplicate Entries

M

mcp6453

My mailing list program accepts Excel 2000 files as input. The
spreadsheet has one email address per row. Is there a way to delete
duplicates, other than sorting and visually scanning?
 
P

Pete_UK

You can make use of Data | Filter | Advanced Filter. In the pop-up you
can specify the range to be filtered, then select Unique Records Only,
and then decide to Filter in place or specify another range where you
want the filtered records to be placed.

Hope this helps.

Pete
 
M

mcp6453

I think that did it. Thanks.

Pete_UK said:
You can make use of Data | Filter | Advanced Filter. In the pop-up you
can specify the range to be filtered, then select Unique Records Only,
and then decide to Filter in place or specify another range where you
want the filtered records to be placed.

Hope this helps.

Pete
Click to expand...
 
Top