How to get rid of duplicates in Excel?...

[frank]

Is there a command that I can use that will go through and delete
duplicates? I have a spreadsheet with just e-mails and there are dups. I am
using Excel 2003...thanks!

Frank

 

[Niek Otten]

Hi Frank,

http://xldynamic.com/source/xld.Deleting.html

Use IE, not Firefox

 

[frank]

Not sure what to do with the code? Is there an easier way?

I read the page..but..what do I do from there?

Thanks!

Frank

 

[dominicb]

Good afternoon Frank

I have an add-in available free of charge to anyone requesting it b
e-mail, which has a tool called Duplicate Manager which should identif
duplicates with an option to highlight or remove them. If you want thi
please drop me a line.

HTH

DominicB
(e-mail address removed)

 

[frank]

Nevermind...got it...

http://office.microsoft.com/en-us/assistance/HA010346261033.aspx

 

[frank]

Just dropped u a note...