Deduping

[Shiblie Bshara]

Hi,
I have excel 2003 and I need to remove duplicates.

any help is appreciated.

best regards.

Shiblie

 

[FSt1]

hi,
see this site....
http://cpearson.com/excel/Duplicates.aspx

regards
FSt1

 

[JP]

We can help you if you post some of your data and give more details.


Thx,
JP

 

[Shiblie Bshara]

Hey again,

the file is a contact details collected from multi sources so I would have
something like:

Name Phone #
Company 1 000000000
Company 2 111111111
Company 3 22222222
Company 1 000000001



thanks in advance


Shiblie.B

 

[Matt Richardson]

Hi there.

Try this link, which may help you with your problem:-

http://support.microsoft.com/kb/262277

Let us know how you get on,

Kind regards,
Matt Richardson
http://teachr.blogspot.com

 

[P D Sterling]

I wasn't in on this thread, but I need to thank you for posting, as I
have wondered this for ages. Some minds make the presumption that
"duplicates" are EXACT duplicates, when in fact, I often need to analyze
which of 2 I would like to delete. Thanks (would insert flowers here but
don't know how to)

Regards,

P D Sterling
New York, Texas & Texas, New York

 

[JP]

Thanks, but you need to explain the desired outcome. Do you want a
list of unique companies? Phone numbers? Something else?

--JP

 

[Evgeny Grischenko]

Hi!
Please, try a small add-in that i usually use often:
http://www.office-excel.com/excel-addins/remove-duplicates-excel.html
Best regards,
Eugene