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:[TABLE="width: 582"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column 1[/TD]
[TD]Column 2[/TD]
[TD]Column 3[/TD]
[/TR]
[TR]
[TD]Wilson, Jack[/TD]
[TD]Ryan, Tommy, John, Chris, Wilson[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]Tommy, Alex[/TD]
[TD]Ryan, Chris[/TD]
[TD]FALSE[/TD]
[/TR]
</tbody>[/TABLE]
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:[TABLE="width: 582"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column 1[/TD]
[TD]Column 2[/TD]
[TD]Column 3[/TD]
[/TR]
[TR]
[TD]Wilson, Jack[/TD]
[TD]Ryan, Tommy, John, Chris, Wilson[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]Tommy, Alex[/TD]
[TD]Ryan, Chris[/TD]
[TD]FALSE[/TD]
[/TR]
</tbody>[/TABLE]
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!