ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   compare rows for a match and sum the matches (https://www.excelbanter.com/excel-worksheet-functions/229429-compare-rows-match-sum-matches.html)

Bert

compare rows for a match and sum the matches
 
How do I compare numbers say d101:l101 with c17:k17 and count the number of
matches between the 2 ranges?

Glenn

compare rows for a match and sum the matches
 
Bert wrote:
How do I compare numbers say d101:l101 with c17:k17 and count the number of
matches between the 2 ranges?



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

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


All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com