skrev i en meddelelse
ups.com...
Hi,

I am a newbie with this so please forgive me if there is an easy
soloution for this.

I have two rows of data, I want to compare these two rows and count how
many numbers within these two rows match and return a count. Can anyone
possibly give me a bit of advice on how to do this?

Thanks
Owen


Hi Owen

One way.

Takes into account duplicates in B1:K1 in itself, duplicates in C2:J2 in
itselft
and values in B1:K1 also found in C2:J2:

=SUMPRODUCT((FREQUENCY((B1:K1,C2:J2),(B1:K1,C2:J2) )1)*(FREQUENCY((B1:K1,C2:J2),(B1:K1,C2:J2))))


--
Best regards
Leo Heuser

Followup to newsgroup only please.