I'm trying to create something that will identify a a 10 character sequence within a group of other characters in the same cell, compare it with a set of similar data in an adjacent column, and identify whether that same 10 character sequence appears anywhere in the second column.
The cells that may contain matching references are not typically in adjacent cells, only adjacent columns, and the data can be thousands of rows long.
The characters that must be matched will always be 10 adjacent characters, but the text they are within is not always the same length, not is the positioning within it the same.
Any help much appreciated!
The cells that may contain matching references are not typically in adjacent cells, only adjacent columns, and the data can be thousands of rows long.
The characters that must be matched will always be 10 adjacent characters, but the text they are within is not always the same length, not is the positioning within it the same.
Any help much appreciated!