 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Display duplicate records?
I have a list of over 13000 of my customer names. Many of the customers have the same name, but are at a different address. I need to identify those with a duplicate name. I don't want to delete them, I just want to highlight or otherwise identify them. Any ideas?  SignatureThanks, Diane Chip Pearson has lots of techniques to work with duplicates: http://www.cpearson.com/excel/Duplicates.aspx > I have a list of over 13000 of my customer names. Many of the customers have > the same name, but are at a different address. I need to identify those with [quoted text clipped - 4 lines] > Thanks, > Diane SignatureDave Peterson You can sort the data by name, so that all identical names come together. Then it is quite easy to introduce a formula like: =IF(OR(A2=A1,A2=A3,"Duplicate","Unique") in a helper column in row 2, and then copy this down the column (this assumes that names are in column A). You can then fix the values, so the description is then tagged with the name. If the original order of the data is important to you, then you can put a simple sequence 1,2,3 etc down another helper column first, and then you will be able to re-sort the data back into that order once you have done the above. Hope this helps. Pete > I have a list of over 13000 of my customer names. Many of the customers have > the same name, but are at a different address. I need to identify those with [quoted text clipped - 4 lines] > Thanks, > Diane Sorry, missed a bracket in the formula: =IF(OR(A2=A1,A2=A3),"Duplicate","Unique") Apologies. Pete > You can sort the data by name, so that all identical names come > together. Then it is quite easy to introduce a formula like: [quoted text clipped - 24 lines] > > - Show quoted text - Thanks Pete and Dave. That's exactly what I needed! SignatureDiane Sorry, missed a bracket in the formula: =IF(OR(A2=A1,A2=A3),"Duplicate","Unique") Apologies. Pete > You can sort the data by name, so that all identical names come > together. Then it is quite easy to introduce a formula like: [quoted text clipped - 29 lines] > > - Show quoted text - Glad to be of help, Diane - thanks for feeding back. Pete > Thanks Pete and Dave. That's exactly what I needed! > [quoted text clipped - 44 lines] > > - Show quoted text - |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.