i want to find same value in these data in excel how can i do that?-CodePudding

I want to find same value in these data in excel how can I do that?

a1=[1,2,3,4,5], b1=10,11,9
a2=[7,8,9], b2=8,5,2

for example compare a1 and b1 result is not match in c1 and for a2 and b2 it should print match in c2

CodePudding user response：

You might need to explain your question a little more clearly, but here's an attempt:

Column C1 can be given the formula

=IF(A1=B1,"match","not match")

Then you can copy that formula down for as many rows as you want.

CodePudding user response：

Perhaps may be something along the lines :

• Formula used in cell C1

=IF(SUM(N(ISNUMBER(XMATCH(TEXTSPLIT(B1,,","),
TEXTSPLIT(A1,{"[","]"},",",1))))),"","Not ")&"Match"