Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
I need to find out how many rows in column B match with rows of column A.
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
Required, but never shown