H
hjopertham
Hello,
can anyone help me find a solution to another slightly different
duplicates problem. I'm trying to count how many identical numbers
there are between two ranges that may contain duplicates.
Can anyone help me to edit a formula that Ron Rosenfeld so kindly
provided, so that it counts the matches?
=IF(SUMPRODUCT(--(COUNTIF(A2:H2,A1:H1)=COUNTIF(A1:H1,A1:H1)))=COUNT(A1:H1),"MATCH","No
Match")
Previous post's example
Range 1 A1:H1___ 8 2 8 14 3 6 4 8
Range 2 A2:H2___14 2 3 4 8 6 8 8
Formula result =8
example 2
Range 1 F1:J1____ 8 2 8 14 3 3 3 3 3
Range 2 O5:O_____8 14 14 3 3
Formula result =4
example 3
Range 1 F1:J1____ 8 2 8 14 3
Range 2 O5:O9____14 8 14 8 8
Formula result =3
The solution provided by Domenic to a different question does provide
the correct answers. Unfortunately his formula requires that I specify
the row and column so it isn't practical for my numerous needs.
All assistance gratefully received.
Regards
James
can anyone help me find a solution to another slightly different
duplicates problem. I'm trying to count how many identical numbers
there are between two ranges that may contain duplicates.
Can anyone help me to edit a formula that Ron Rosenfeld so kindly
provided, so that it counts the matches?
=IF(SUMPRODUCT(--(COUNTIF(A2:H2,A1:H1)=COUNTIF(A1:H1,A1:H1)))=COUNT(A1:H1),"MATCH","No
Match")
Previous post's example
Range 1 A1:H1___ 8 2 8 14 3 6 4 8
Range 2 A2:H2___14 2 3 4 8 6 8 8
Formula result =8
example 2
Range 1 F1:J1____ 8 2 8 14 3 3 3 3 3
Range 2 O5:O_____8 14 14 3 3
Formula result =4
example 3
Range 1 F1:J1____ 8 2 8 14 3
Range 2 O5:O9____14 8 14 8 8
Formula result =3
The solution provided by Domenic to a different question does provide
the correct answers. Unfortunately his formula requires that I specify
the row and column so it isn't practical for my numerous needs.
All assistance gratefully received.
Regards
James