Finding cells with matching data
COL A has 2,374 cells containing 9-character strings that look like
this:
102050013
102050016
110103030
116300004
161180034
COL B contains 4,800 cells containing up to 27-characters strings that
look like this:
102050001102050013
102050011102050016
106211018116040018116300004
110103012110103030
116040018116300004
161180032161180034
170212022170212025
174301015174301034174301040
174301017174301036174301041
174301034174301040
174301036174301041
174320014174320025
179221003179221008179221016
How do I search for strings in COL B that match strings in COL A?
|