Hi I have a challenge where I have to compare the coma separate values from 2 columns (Column A , Column B and find the sequentially comma separated matching values and output to Results column.
Example:
Compare "Column A" values (Coma Separated ) with "Column B" (Coma Separated) and output the sequentially comma separated matching Values (Coma Separated) to "Result" column
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 190px"><col width="185"><col width="249"><col width="668"></colgroup><tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Result[/TD]
[TD]Required[/TD]
[/TR]
[TR]
[TD]apple,,4,[/TD]
[TD]apple,9,4,mango[/TD]
[TD]apple,9,4,mango / (not matched)[/TD]
[TD]In result color the string with red which is not in Coloumn A[/TD]
[/TR]
[TR]
[TD]apple,mango,banana,14,4[/TD]
[TD]apple,mango,,14,[/TD]
[TD]apple,mango,banana,14,4 / (matched)[/TD]
[TD]Replace column B comma seperated empty value with exact comma seperated dataset value place of column A[/TD]
[/TR]
[TR]
[TD]apple,mango,banana,14,4[/TD]
[TD]apple,mango,lemon,14,4[/TD]
[TD]not matched[/TD]
[TD]if any value not match, example - as banana in column A and Lemon in colomn B mismatch result into not matched[/TD]
[/TR]
[TR]
[TD]apple,mango,banana,14,4[/TD]
[TD]apple,mango,banana,14,4[/TD]
[TD]matched[/TD]
[TD]if all value match result into matched[/TD]
[/TR]
</tbody>[/TABLE]
Any help is greatly appreciated.
Example:
Compare "Column A" values (Coma Separated ) with "Column B" (Coma Separated) and output the sequentially comma separated matching Values (Coma Separated) to "Result" column
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 190px"><col width="185"><col width="249"><col width="668"></colgroup><tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Result[/TD]
[TD]Required[/TD]
[/TR]
[TR]
[TD]apple,,4,[/TD]
[TD]apple,9,4,mango[/TD]
[TD]apple,9,4,mango / (not matched)[/TD]
[TD]In result color the string with red which is not in Coloumn A[/TD]
[/TR]
[TR]
[TD]apple,mango,banana,14,4[/TD]
[TD]apple,mango,,14,[/TD]
[TD]apple,mango,banana,14,4 / (matched)[/TD]
[TD]Replace column B comma seperated empty value with exact comma seperated dataset value place of column A[/TD]
[/TR]
[TR]
[TD]apple,mango,banana,14,4[/TD]
[TD]apple,mango,lemon,14,4[/TD]
[TD]not matched[/TD]
[TD]if any value not match, example - as banana in column A and Lemon in colomn B mismatch result into not matched[/TD]
[/TR]
[TR]
[TD]apple,mango,banana,14,4[/TD]
[TD]apple,mango,banana,14,4[/TD]
[TD]matched[/TD]
[TD]if all value match result into matched[/TD]
[/TR]
</tbody>[/TABLE]
Any help is greatly appreciated.