View Single Post
  #1   Report Post  
sun1x
 
Posts: n/a
Default How to compare two cells for the same numbers


Is there a way to compare two cells to see how many
numbers are same?

For example, A2 contains 16, 17, 19; B2 contains 16, 17; and I want to
put
in C2 the result 2. What is the formula for this?

Thanks


--
sun1x
------------------------------------------------------------------------
sun1x's Profile: http://www.excelforum.com/member.php...o&userid=28327
View this thread: http://www.excelforum.com/showthread...hreadid=479096