Find common data in two cells having values separated by comma

[Prascena]

Hello,

Can anyone help me with formula to get the Output (Column C in attached image

Column A and Column B have some numbers (Alpha Numeric) separated by comma. If they have any common number, then I need Column C value to be "Yes" and if not I need value to be "No".

Can anyone help with this?

Thank you in advance.

 

[RoryA]

A gentle reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Match data separated by comma
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.