compare rows for a match and sum the matches

B

Bert

How do I compare numbers say d101:l101 with c17:k17 and count the number of
matches between the 2 ranges?
 
G

Glenn

Bert said:
How do I compare numbers say d101:l101 with c17:k17 and count the number of
matches between the 2 ranges?
Click to expand...


Array-formula (commit with CTRL+SHIFT+ENTER):

=SUM(--(C17:K17=TRANSPOSE(D101:L101)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I? 1
Compare last digit in 5 cells for match 0
Inconsistent formatting of section numbers 0
Finding the proper style field and the numbered paragraph value within the style 0
Identifying common data between 2 cells 1
Macro for comparing columns and highlighting matching/differences 13
Finding the right style field in VBA 0
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2

Top