armchairandy
Board Regular
- Joined
- Mar 27, 2012
- Messages
- 53
I am looking to compare two columns A & B and find if there are any sub-strings that are the same & Infill column C either with the same text or 1 if it matches - whichever is easier
<tbody>
</tbody>
The values of each column can be numbers, text or numbers & text.
I do not necessarily need the same text extracted to column C, a 1,0 would be sufficient. I have thousands of rows in each column and therefore would be looking for a formula rather than VBA. I have seen some similar examples on the board, but none that would meet my needs. If there is more than one sub-string present they are always differentiated by "` " with a space after the character, and the sub-string is a varying length.
Any help would be appreciated
Regards
Andrew
Col A | Col B | Col C | Alt Col C | |
R5 | 201F35 | 030` 020` 712 | 0 | 0 |
R6 | NFL1006235` 1001 | 1001 | 1001 | 1 |
R7 | 050` 070` 010 | 070 | 070 | 1 |
R8 | 125` PP120653 | PP120653` 5001` 100`125 | PP120653` 125 | 1 |
R9 | 040` 050` 060 | 060` 1001 | 060 | 1 |
R10 | 2222` 234` QF45 | 561` GH675` 1234 | 0 | 0 |
<tbody>
</tbody>
The values of each column can be numbers, text or numbers & text.
I do not necessarily need the same text extracted to column C, a 1,0 would be sufficient. I have thousands of rows in each column and therefore would be looking for a formula rather than VBA. I have seen some similar examples on the board, but none that would meet my needs. If there is more than one sub-string present they are always differentiated by "` " with a space after the character, and the sub-string is a varying length.
Any help would be appreciated
Regards
Andrew