Newb Question - Filter Address List

  • Thread starter Thread starter stupid_idiot
  • Start date Start date
S

stupid_idiot

Working on a Master Mailing Political Campaign list.....any tutorials on how to quickly devise a filter to eliminate redundant
mailing addresses?

TIA!
 
Insert a new worksheet.
Select your data range on original sheet.
Data>Filter>Advanced Filter.
Check "Unique records only" and "copy to a new location".

Your "listrange" will be already entered. In the "copy to" click on the
Collapse Dialog button and select your new worksheet A1.

OK your way out.

You can now delete the original list.

Filtering Tutorial at Debra Dalgleish's site.......
http://www.contextures.on.ca/tiptech.html

More on Duplicates marking, preventing at Chip Pearson's site....
http://www.cpearson.com/excel/topic.htm

Scroll down to "D" section and select Duplicate topics.

Gord Dibben Excel MVP XL2002
 
Back
Top