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

Something like =MATCH("*"&a1&"*",$a$1:a2,0) in B1 ( pull down as needed)
This will return there n indicating a partial match of the value contained in the nth cell

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post