Hi guys,
I am doing retrospective research in liver enzyme's elevated patients .
I am have two columns of ID's ( around 30,000-50,000) which i want to compare and see if there is a match.
I do want a partial match between the numbers in each column of 5 digits .
A is the premanent group.
C is a changable group of ID's that i want to compare each time to A.
I want that the matched number will be on B .
Is it possible?
How do i do that ?
Help please
<tbody>
</tbody>
I am doing retrospective research in liver enzyme's elevated patients .
I am have two columns of ID's ( around 30,000-50,000) which i want to compare and see if there is a match.
I do want a partial match between the numbers in each column of 5 digits .
A is the premanent group.
C is a changable group of ID's that i want to compare each time to A.
I want that the matched number will be on B .
Is it possible?
How do i do that ?
Help please
A | B | C |
11123400 | 11123400 | 111234 |
11189004 | 2234980 | |
3339000 | 3339000 | |
88890800 | 3339099 |
<tbody>
</tbody>