|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
07-21-2017, 06:01 AM
|
|||
|
|||
Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell?
I have a spreadsheet that contains 5257 rows of data. One of the column names in this spreadsheet is Asset Name.
This column contains data as follows: 32413 36756 33615 LOM32413 LPA36756 LAL33615 In my application of this data, LOM32413 is a duplicate of the 32413 entry. Is there a way I can use a formula to have Excel find this type of "duplicate" entries when only PART of the cell's data is a duplicate of the entirety of another cell? Any help or suggestions are appreciated. Thanks! JoAnn 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Duplicate Calendar Entries from Office to Personal mail
|
dylansmith | Outlook | 1 | 04-26-2017 04:34 AM |
| Duplicate entries | yourforester | Outlook | 1 | 11-15-2014 10:44 PM |
| Calendar - Duplicate Entries | castow | Outlook | 0 | 02-05-2014 02:53 PM |
| Removing duplicate index entries | Bengt | Word | 5 | 03-01-2013 02:01 AM |
| How Can I Flag Duplicate Date Entries? | tatihulot | Excel | 5 | 11-16-2012 12:19 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode