View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GARY GARY is offline
external usenet poster
 
Posts: 117
Default Finding cells with matching data

COL A has 2,374 cells whose contents look like this:

102050013
102050016
110103030
116300004
161180034
170212025
174301040
174301041
174320025
179221016
190040026
191313016
209241034
210110044


COL B has 4,690 cells whose contents look like this:

102050001102050013
102050011102050016
106211018116040018116300004
110103012110103030
116040018116300004
161180032161180034
170212022170212025
174301015174301034174301040
174301017174301036174301041
174301034174301040
174301036174301041
174320014174320025
179221003179221008179221016
179221008179221016
179221011179221016
190040023190040026
191313002191313016
209241026209241034
210110009210110044
211183002211183027
243020014243020035


The contents of the cells in COL A occur somewhere in the cells in COL
C.

Two examples:
110103030 is contained in A3 and also in C4.
174320025 is contained in C12 and also in C12.

How can I find these matches?