Formula for checking numbers

  • Thread starter Thread starter Jeff Donahue
  • Start date Start date
J

Jeff Donahue

If I have a string of 5 numbers in cells a1..a5, I am
looking to create a formula whereby I can put 5 random
numbers in cells b1..b5 and the formula in B6 will
calculate and tell me how many numbers in row B match from
the numbers in row A.

Can anyone help?

Thanks

Jeff Donahue
 
Back
Top