Hello Group, I have an excel file that have large number of data (both numbers and texts). My query relates to detecting the values that are duplicate in nature, however distinguished by a single text or number. For example:
Inv Number 123 123A 123B 123C In the above example, the number is same, however an extra text has been entered (A,B,C, etc). To add to the confusion, the length of the text is also not ascertainable. Would request you all if anyone could provide me a way or a macro that finds out these values from a large set of data and then delete the duplicate ones i.e. do not delete 123 and delete 123A,123B,123C. I hope my query is clear. Please let me know if you have any questions. -- Thanks & Regards Ankit Mehra --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
