| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a sum by matching two cells with the same identifier | Excel Discussion (Misc queries) | |||
| Finding matching cells | Excel Discussion (Misc queries) | |||
| Finding matching cells | Excel Discussion (Misc queries) | |||
| finding matching cells in worksheets | Excel Worksheet Functions | |||
| finding matching cells in worksheets | Excel Programming | |||
Threaded Mode
