Sumproduct Help Please
Hang on. Didn't you ay in the OP that it DOES give 3 (which it did in my
tests), and that you wanted 1?
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"Paul Black" wrote in message
ups.com...
Thanks for the Reply Bob,
Within the 6 Numbers 1 2 3 4 19 & 24 and my Second set of Numbers 2 19
& 24 there are 3 Matching ( in this Particular Case ) Pairs ...
Pair 1 = 2 19
Pair 2 = 2 24
Pair 3 = 19 24
... so I would like the Resulting Formula to Return 3 ( 1 for Each Pair
Matched ) Please.
Thanks in Advance.
All the Best.
Paul
|