Comparing two columns in Microsoft Excel
I have 2 columns A & B both sorted from small to large. A has about 600 entries. B has around 300. Every number in B is included in A. What I would like to be able to do is in another column mark whether or not A is included in B.Should look like this when finished.Thanks.
A B C 1 3 N 2 4 N 3 7 Y 4 8 Y 5 N 6 N 7 Y 8 Y