is this a match ?

[Orangeanorak]

Can you please give me the formula to display the following

I have ten numbers in A1-A10

I have ten numbers in B1-B10 etc

in B11 I want to display the total times the numbers in b1:b10 match the numbers in a1:a10

in row A1-A10 3 5 8 11 22 34 37 45 50 53
row B1-B10 4 8 12 22 35 39 50 55 60 75

B11 would show 3

thank you very much for this

 

[shift-del]

Hi

Coincidently there has been a posting with a similar question at chandoo.org. Check it out.
How many values are common in 2 lists? [homework] | Chandoo.org - Learn Microsoft Excel Online