Duplicates - not all the same
 

Hu guys,

I have around 10 k records - i want to get rid of the duplicates..

I know that you can use the advanced filter method...

but problem is that some of the records while are the same are not
exactly identical..

e.g.

They are contacts, so i have a name an address etc

Some of them are from one type of contact group - such as constuction
and some are from other types - such as banking

some contacts belong to both construction and banking

I have to use excel, and i have to record all the data keeping the type
of groups together...

any ideas on how to do this, and get rid of the duplicates??

Cheers


--
blander
------------------------------------------------------------------------
blander's Profile: http://www.excelforum.com/member.php...o&userid=36486
View this thread: http://www.excelforum.com/showthread...hreadid=565936

Duplicates - not all the same
 

When I've had to do this, I eliminate the exact duplicates (advanced filter is
one technique), but then it becomes a manual effort--sorting and checking each
key field.

Jimmy And Sons
Jimmy & Sons
Jimmy & Sons, Inc

Are not duplicates to excel--but they probably are in real life.



blander wrote:

Hu guys,

I have around 10 k records - i want to get rid of the duplicates..

I know that you can use the advanced filter method...

but problem is that some of the records while are the same are not
exactly identical..

e.g.

They are contacts, so i have a name an address etc

Some of them are from one type of contact group - such as constuction
and some are from other types - such as banking

some contacts belong to both construction and banking

I have to use excel, and i have to record all the data keeping the type
of groups together...

any ideas on how to do this, and get rid of the duplicates??

Cheers

--
blander
------------------------------------------------------------------------
blander's Profile: http://www.excelforum.com/member.php...o&userid=36486
View this thread: http://www.excelforum.com/showthread...hreadid=565936

--

Dave Peterson