CODEWITHSUNDEEP
excelexcel-formula
Amirali Shabani
Amirali Shabani

Reputation: 21

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

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

Upvotes: 2

Views: 52

Answers (1)

Mayukh Bhattacharya
Mayukh Bhattacharya

Reputation: 27428

Perhaps may be something along the lines :

enter image description here

• Formula used in cell C1

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

Upvotes: 3

Related Questions