Comparing columns of ata in 2 different sheets to see if they contain equal values

[Jwan622]

I have the following columns of data:
Sheet 1:

Name Date
Stock A 1/3/2013
Stock B 1/3/2012
Stock B.3 null
Stock C 4/5/2013
Stock D 6/2/2013
Stock D.1 null
Stock E 7/21/2013
Stock F 9/28/2013
...




Sheet 2
Stock A 1/3/2013
Stock A.3 4/3/2011
Stock B 1/3/2012
Stock C 4/5/2013
Stock D 6/2/2013
Stock D.5 7/8/2013
Stock E 7/21/2013
Stock F 9/28/2013
Stock F.3 11/21/2013
...


How do I compare if the dates are the same on both pages for each stock? Basically, I just want check if Stock A has the same date info on both sheets. Both sheets have stocks that are different from the stocks on the other sheet, but I don't care about the stocks that they have in common. The differences in stock names is just getting in the way when I try to check equivalency using the Exact function. What do I do here?

 

[oldbrewer]

you are not explaining this clearly - but =countif(sheet2!a1:a20,a1) will tell you how many times Stock A 1/3/2013 occurs on sheet 2