View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do have the data I'm importing look for similar entries

Steff

See Advanced Filter section at Debra Dalgleish's site.

http://www.contextures.on.ca/xladvfi....html#FilterUR


Gord Dibben MS Excel MVP

On Tue, 27 Feb 2007 07:38:00 -0800, Steff
wrote:

I want to combine two address books made in excel that have duplicate
information.
Once I combine them together I don't have to have to look threw 1000+ names
to find duplicates. Is there a function that will do that for me?