There is a remove duplicates option on the Data tab in Excel. It should work to just paste all numbers into Excel if there is one number per line and then sort the column and then remove duplicates. I think this would be worth a try before writing a program. Also, the sort in excel is generally easy to use, so I would consider sorting there even if one does not want to remove duplicates automatically.
If a word document is needed, one could just select the entire column with CONTROL-SPACE and copy it back into word. Doing this may create a table in word, so one might want to use the "Paste" option on the HOME tab on the ribbon and choose text only. Another approach to avoid creating a table is to copy the column into NotePad and then copying the NotePad data into word. You don't have to even save the NotePad document, just use it as a holding area. Of course, there are other ways of doing this as well, this is just one approach. Best regards, Steve Jacobson -----Original Message----- From: Talk [mailto:[email protected]] On Behalf Of Rick Thomas via Talk Sent: Tuesday, December 06, 2016 10:15 AM To: 'Dave' <[email protected]>; 'Window-Eyes Discussion List' <[email protected]> Subject: RE: Finding all Duplicates II Simple really: Depending on the object holding the list you could write a little program to read the list one line at a time, one number at a time. Then look in a new list to see if the number is already there.If so skip adding it again. If not add it to the new list. The technicals depends on what object holds the current list and what tools you have available to you to do this. There are even simpler methods if you have the tools but I have no clue what you have nor what you are familiar with. Rick USA -----Original Message----- From: Talk [mailto:[email protected]] On Behalf Of Dave via Talk Sent: Tuesday, December 6, 2016 10:29 AM To: A I Squared Support <[email protected]> Subject: Finding all Duplicates II Good Morning, Thanks for the several suggestions. Here's a bit more on what I am doing: The Company's Voice Mail has been acting up for a couple of months now. Sometimes it works and sometimes it doesn't. And lately, it hasn't. So when customers call in, if all Customer Service people are busy, the caller should go to voice mail. Well, they don't. they just go away. The phone system does record all numbers calling in, so there is a list of phone numbers. But we have no way of knowing the name of the customer calling, just their number. And some people call every day, or multiple times per day. So in the record there are going to be duplicates. -- And the crazy thing is that there is no way that anyone knows, as how to get this list of numbers out of the Phone Systems records. Now, I am sure there is a file some where on the systems storage, but those who know something about the phone system have no idea where that file would be, or what it would be called. So, the Boss has someone reading me these phone numbers out of the phone system. I then have been typing them out in a Document, as in a long list. Just by hearing the numbers, I can tell when I hear a duplicate number, but this is not fool proof. So I have these phone numbers, in a Word File. Hundreds of phone numbers, and I am to remove the duplicates, because the Boss intends for Customer Service to call all of these numbers back. The Company already looks like idiots since customers are not getting called back, and then to have the poor souls in Customer Service call a customer twice, three times or more, isn't going to look great either. So, I and another have been tasked with getting all of these numbers into a file, to be given to customer service, and with no duplicates. <Smile> Welcome to the Real World when it comes to problem solving. Butch's Sorting in DOS sounds like a possible solution. I can save my document as a Text file. I'll give this a try. Since I have hundreds of numbers to weed through, I was trying to use the power of the computer to strip out the duplicates, rather than having me and this other person go through them one at a time and hoping to remove all duplicates. So thought I would ask the list here, since we have some smart folks here. Grumpy Dave _______________________________________________ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/ofbgmail%40mi. rr.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com _______________________________________________ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/steve.jacobson %40visi.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com _______________________________________________ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/archive%40mail-archive.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com
