B Bert Apr 30, 2009 #1 How do I compare numbers say d101:l101 with c17:k17 and count the number of matches between the 2 ranges?
How do I compare numbers say d101:l101 with c17:k17 and count the number of matches between the 2 ranges?
G Glenn Apr 30, 2009 #2 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)))
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)))
