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