• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

singhcbs

New Member
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.
 

Attachments

  • Query.xlsx
    8.4 KB · Views: 13
Hi !

Tip for a beginner : copy first column in a temp worksheet
then use Excel text to columns inner feature to split data in columns
and operate the same way for second column,
so it's easier to compare cell by cell ...
 
singhcbs
How there can be four possible different results?
> D4: If any value not match ... gives 'not matched'
> D5: If all value match ... gives 'matched'
When 'Required' D2 or D3 would/match need?
for C2 =if(A2=B2,"matched","not matched")
 
Back
Top