Filtering issues

  • Thread starter Thread starter Shauna
  • Start date Start date
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?
 
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
 
Back
Top