Visit Chip's site at www.cpearson.com
He has lots on duplicates
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Zach Gold" <Zach wrote in message
...
Hi,

Haven't used Excel much, so I'm trying to find out how to do something
that
I imagine is very simple.

I have a list of addresses and I want to filter it so I get only entries
that have two categories that exactly match another entry (for instance
last
name and zip code) so that I can delete duplicate addresses.

Any ideas how I would go about doing something like this? Any help would
be
appreciated. Thanks!

-Zach