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
Column AColumn BResultRequired
apple,,4,apple,9,4,mangoapple,9,4,mango / (not matched)In result color the string with red which is not in Coloumn A
apple,mango,banana,14,4apple,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,4apple,mango,lemon,14,4not matchedif any value not match, example - as banana in column A and Lemon in colomn B mismatch result into not matched
apple,mango,banana,14,4apple,mango,banana,14,4matchedif all value match result into matched
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
Column AColumn BResultRequired
apple,,4,apple,9,4,mangoapple,9,4,mango / (not matched)In result color the string with red which is not in Coloumn A
apple,mango,banana,14,4apple,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,4apple,mango,lemon,14,4not matchedif any value not match, example - as banana in column A and Lemon in colomn B mismatch result into not matched
apple,mango,banana,14,4apple,mango,banana,14,4matchedif all value match result into matched
Any help is greatly appreciated.