Duplicate Entries

[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?

 

[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

 

[mcp6453]

I think that did it. Thanks.

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

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

I think that did it. Thanks.






- Show quoted text -