Thread: Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell?
View Single Post
 
Old 07-21-2017, 06:01 AM
jsisley jsisley is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Jul 2017
Posts: 1
jsisley is on a distinguished road
Default 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
Reply With Quote