Remove Duplicate number,How?

[bleach]

i have thousand of phone number and my freelancer will add new phone number everyday.
But i want to remove duplicate numbers. How to do it?
many thanks for your help.
(phone numbers are in Notepad Files)
For example

1234567890
1233636309
1515724350
1241551451
1234567890

 

[auggie101]

you can check it through excel.. just copy the files paste it in excel, "select all" the files then in the upper part of the excel window - click "DATA" then click "remove duplicates".. All duplicates fields will be removed..

Hope it helps..

 

[VeteranSEO]

Or if you have it in SQL you can just do a distinct.

 

[HoNeYBiRD]

you can do it with Notepad++:
navigate to TextFX/TextFX Tools, make sure "sort outputs only UNIQUE (at column) lines" is checked, hit Ctrl+A to select the entire document, then click "sort lines case sensitive (at column)" or "sort lines case insensitive (at column)"

that's all, duplicate lines (in this case numbers) are removed

 

[noermanto]

Wow! all the three method were awesome.
I thanked to all of you.
Usually I just use some online duplicate remover (search using G)

 

[HoNeYBiRD]

Wow! all the three method were awesome.
I thanked to all of you.
Usually I just use some online duplicate remover (search using G)

yea, there are a bunch of online tools as well, but use them with caution, your leads may be stolen!

 

[noermanto]

Or if you have it in SQL you can just do a distinct.

Can you explain more..

 

[bleach]

you can do it with Notepad++:
navigate to TextFX/TextFX Tools, make sure "sort outputs only UNIQUE (at column) lines" is checked, hit Ctrl+A to select the entire document, then click "sort lines case sensitive (at column)" or "sort lines case insensitive (at column)"

that's all, duplicate lines (in this case numbers) are removed

nice support

 

[AboutBizz]

Here are FIVE WAYS...two which were mentioned. Good info with examples:
http://www.mrexcel.com/tip138.shtml