advance filter unique records except on column

[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?

 

[Dave Peterson]

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.

 

[Herb Segal]

Thank you so much. It worked!

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.