CODEWITHSUNDEEP
excelexcel-formula
Nappy
Nappy

Reputation: 11

Matching Pairs Problem in excel using basic functions

May I know how to check whether the Current Pairs match with the Ideal Pairs by using excel functions?

For example: The Current Pair of 1&8 does not match with the Ideal Pair of 1&14 and 1&29

I would also like to count the total number of matching pairs at the end. I have tried out different methods by using countifs() or match(), but in vain.

Appreciate your answer!

enter image description here

Upvotes: 0

Views: 45

Answers (1)

Harun24hr
Harun24hr

Reputation: 36890

You can try below formula to count all matching pairs.

=SUM(--(IFERROR(XMATCH(B2:B7&C2:C7,F2:F7&G2:G7,0),0)>0))

enter image description here

Upvotes: 1

Related Questions