advance filter unique records except on column

  • Thread starter Thread starter Herb Segal
  • Start date Start date
H

Herb Segal

Is there a way to filter a database to find unique records where one column
is ignored?

I have over 6,000 records with the following columns.

Cust_rec, Bco, pol_csr, Expires, Cust_name, Cust_attn, Pol_type

I want to eliminate duplicates (there are many) but the last column "policy
type" should be disregarded.

Any suggestions?
 
You could use data|filter|advanced filter (in xl2003 menus).

Select the first 5 columns in your table and excel will use that in the advanced
filter dialog.

Make sure you check the "Unique records only" checkbox.
 
Thank you so much. It worked!

Dave Peterson said:
You could use data|filter|advanced filter (in xl2003 menus).

Select the first 5 columns in your table and excel will use that in the
advanced
filter dialog.

Make sure you check the "Unique records only" checkbox.
Click to expand...
 
Back
Top