Hello all,
I am newbie in this forum and excel VB. I have a hard time to find duplicate value when comparing multiple values in 2 separate cells. As there are many record i'll need to compare, so would like seek help here and solve the problem by VB. Example as below:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>
To compare the names (each name will be separate by comma) between column 1 and 2, if there is duplicate value (e.g. Wilson), will return "TRUE" in column 3.
Thanks!
I am newbie in this forum and excel VB. I have a hard time to find duplicate value when comparing multiple values in 2 separate cells. As there are many record i'll need to compare, so would like seek help here and solve the problem by VB. Example as below:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Column 1 | Column 2 | Column 3 |
Wilson, Jack | Ryan, Tommy, John, Chris, Wilson | TRUE |
Tommy, Alex | Ryan, Chris | FALSE |
<tbody>
</tbody>
To compare the names (each name will be separate by comma) between column 1 and 2, if there is duplicate value (e.g. Wilson), will return "TRUE" in column 3.
Thanks!