I agree that the Excel function to remove duplicates would be my approach. I've used it several times recently on large data files. As long as you are typing the numbers consistently, e.g., with the same punctuation, this will work. Simply select all the numbers in your word document, then put your cursor in the first cell in a blank worksheet in Excel. Hit Control V to paste and each number should get pasted as a new row in Excel. Then, go to the Data ribbon and tab over to Remove duplicates. When you click on that, a dialog box will appear. Tab through the options. By default, the single column with your phone numbers in it will be checked and you may need to check or uncheck the box for whether your data has a header row. Hit OK and Excel will do the work for you, plus tell you how many rows were removed. Just as an FYI for anyone curious, the dialog box allows you to select the columns so that, for example, if your data could have duplicates in column A that you w ant to remove, but you do not want it to filter any duplicates from column C, you can specify that.
Pivot tables is another way I'd handle this, but that's pretty complex for explaining. Good luck. Other than the typing of all those numbers, this sound like a fun research project to me, but I'm a geek for Excel sometimes. -----Original Message----- From: Talk [mailto:[email protected]] On Behalf Of Dave via Talk Sent: Tuesday, December 06, 2016 8:29 AM To: A I Squared Support 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/robin_van_lant%40key.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 This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information. 127 Public Square, Cleveland, OH 44114 If you prefer not to receive future e-mail offers for products or services from Key send an e-mail to mailto:[email protected] with 'No Promotional E-mails' in the SUBJECT line. _______________________________________________ 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
