I need to find out how many rows in column B match with rows of column A.

enter image description here

New contributor
Rishabh Shrivastava is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • If you actually need to find the differences, you will need to sort both columns individually, then in C compare both. – LPChip Mar 26 at 10:25

In C1 use =COUNTIFS(A:A,B1) and drag down.

Then sum up col C.

This will count double matches too. i.e if B1 is found twice it will count it as 2.

If you only want to know the unique matches use =MIN(1,COUNTIFS(A:A,B1)) instead and apply same method

  • 1
    Worked Fine. Now 1299 of them matched. How do i Know Which ones didn't match? – Rishabh Shrivastava Mar 26 at 11:19
  • 1
    the ones that come up as 0 haven't matched. if this works for you consider accepting this answer as correct – PeterH Mar 26 at 11:22

Your Answer

Rishabh Shrivastava is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.