View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Zach Gold Zach Gold is offline
external usenet poster
 
Posts: 1
Default crossreferencing duplicate entries

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