Compare two columns of values

[levoxy]

I have two columns with values that needs to be compared and difference values need to be printed in separate column.

[TABLE="width: 500"]
<tbody>[TR]
[TD]value1[/TD]
[TD]value2[/TD]
[TD]difference[/TD]
[/TR]
[TR]
[TD]apple,curd,milk[/TD]
[TD]orange,apple,water[/TD]
[TD]curd,milk,orange,water[/TD]
[/TR]
[TR]
[TD]pen,paper,bag[/TD]
[TD]bag,paper,belt[/TD]
[TD]pen,belt[/TD]
[/TR]
</tbody>[/TABLE]

please help.

 

[levoxy]

Re: Please help with compare

Hello, I tried it the same way. it is not working.did not get any results.

 

[YasserKhalil]

Re: Please help with compare

Yes it is working for me. I usually tests the code before posting it
Can you upload sample of your workbook?

 

[levoxy]

sorry. I had my excel different format. column a was the values1 which was derived from another sheet, col B was the input, Col c was values2 again derived from another sheet. so due to the issue of values1 is showing up only formulae but not the actual values due to this the code is not working.

I have done this assignment as a simpler logic than this by just displaying there is mismatch not actually displaying the mismatch difference.

Thanks for the effort.