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
 
Thanks Gord for the tip...will try it on my work machine tomorrow...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA: How can I use a string variable as autofilter criteria? 4
Update Filter List AFTER Filter Applied 3
Sercah for attributes within name 1
BCM 2010 and mail merge (mass mail) problem 0
Cleaning up a spreadsheet 3
Meet Mycroft: An Open Source Virtual Assistant 3
Marketing Campaign Create List 4
filter issue 1

Back
Top