Compare sequentially Coma Separated Values from two columns and give matching values - Help Needed

[singhcbs]

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>

Column A	Column B	Result	Required
apple,,4,	apple,9,4,mango	apple,9,4,mango / (not matched)	In result color the string with red which is not in Coloumn A
apple,mango,banana,14,4	apple,mango,,14,	apple,mango,banana,14,4 / (matched)	Replace column B comma seperated empty value with exact comma seperated dataset value place of column A
apple,mango,banana,14,4	apple,mango,lemon,14,4	not matched	if any value not match, example - as banana in column A and Lemon in colomn B mismatch result into not matched
apple,mango,banana,14,4	apple,mango,banana,14,4	matched	if all value match result into matched

<colgroup><col style="width: 190px"><col width="185"><col width="249"><col width="668"></colgroup><tbody>
</tbody>

Any help is greatly appreciated.