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

--
Kind regards,

Niek Otten

"frank" <frankmcma @ yahoo.com> wrote in message
news:vbQwf.57253$XJ5.17707@twister.nyroc.rr.com...
> 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
>

[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

"Niek Otten" <nicolaus@xs4all.nl> wrote in message
news:exJAMrfFGHA.3892@TK2MSFTNGP12.phx.gbl...
> Hi Frank,
>
> http://xldynamic.com/source/xld.Deleting.html
>
> Use IE, not Firefox
>
> --
> Kind regards,
>
> Niek Otten
>
> "frank" <frankmcma @ yahoo.com> wrote in message
> news:vbQwf.57253$XJ5.17707@twister.nyroc.rr.com...
>> 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
>>
>
>

[dominicb]

Good afternoon Frank

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

HTH

DominicB
dominic@dom-and-lis.co.uk

[frank]

Nevermind...got it...

http://office.microsoft.com/en-us/as...346261033.aspx



"frank" <frankmcma @ yahoo.com> wrote in message
news:U5Swf.57720$XJ5.39273@twister.nyroc.rr.com...
> 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
>
> "Niek Otten" <nicolaus@xs4all.nl> wrote in message
> news:exJAMrfFGHA.3892@TK2MSFTNGP12.phx.gbl...
>> Hi Frank,
>>
>> http://xldynamic.com/source/xld.Deleting.html
>>
>> Use IE, not Firefox
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "frank" <frankmcma @ yahoo.com> wrote in message
>> news:vbQwf.57253$XJ5.17707@twister.nyroc.rr.com...
>>> 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
>>>
>>
>>
>
>

[frank]

Just dropped u a note...

"dominicb" <dominicb.21fjgm_1136914800.3812@excelforum-nospam.com> wrote in
message news:dominicb.21fjgm_1136914800.3812@excelforum-nospam.com...
>
> Good afternoon Frank
>
> I have an add-in available free of charge to anyone requesting it by
> e-mail, which has a tool called Duplicate Manager which should identify
> duplicates with an option to highlight or remove them. If you want this
> please drop me a line.
>
> HTH
>
> DominicB
> dominic@dom-and-lis.co.uk
>
>
> --
> dominicb
> ------------------------------------------------------------------------
> dominicb's Profile:
> http://www.excelforum.com/member.php...o&userid=18932
> View this thread: http://www.excelforum.com/showthread...hreadid=499761
>