Filtering issues

S

Shauna

I have an excel sheet full used as a mailing list. The
list is over 8,000 records. I need to filter the
duplicates out, problem being that they came from 8
different XLS tables, which were all formatted
differently, so even duplicate records usually differ
slightly. How can I select two columns as criteria for
filtering the whole list?
 
P

Paul Corrado

Shauna,

A two step approach should work.

Step One:

Move the two columns so that they are next to one another.

Then Data|Filter|Advanced Filter

Under Action select Copy to Another Location

Set the two columns as the List Range

Leave Criteria Blank

Select a blank space in the worksheet as the Copy To range. (You need only
reference the upper left cell of the range)

Select Unique Records Only Option


Step 2

Copy the two Column Headings from your original data list to the columns in
your unique list.

Use those two columns as the criteria for a second Data|Filter|Advanced
Filter

HTH

PC
 

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

Top