How do have the data I'm importing look for similar entries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steff - 27 Feb 2007 15:38 GMT

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?

Reply to this Message

Gary''s Student - 27 Feb 2007 16:18 GMT

See:

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

Signature

Gary''s Student
gsnu200708

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

Reply to this Message

Gord Dibben - 27 Feb 2007 18:20 GMT

Steff

See Advanced Filter section at Debra Dalgleish's site.

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

Gord Dibben MS Excel MVP

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

Reply to this Message