0

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

enter image description here

1
  • If you actually need to find the differences, you will need to sort both columns individually, then in C compare both.
    – LPChip
    Mar 26, 2020 at 10:25

1 Answer 1

2

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

2
  • 1
    Worked Fine. Now 1299 of them matched. How do i Know Which ones didn't match? Mar 26, 2020 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, 2020 at 11:22

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .