matching 2 columns of data

K

karen

Hi
How do I match up 2 columns of data to see if any data in column A matches
any data in column B, and put this in column C?
Thanks
 
K

karen

Thanks Bob. Presume that just compares A1 to B1 and so on...Do you know how
you would compare the whole of column A to column B?
Thanks.
 
B

Bob I

I don't understand the the question. Do you mean do the contents of all
the cells in column a equal all the contents of cell of column b? What
are you checking for? You asked for any matches, if they all match then
there will be no blank cells in column C. Or use Countif and see that
the number of C cells that are not "" equals the number of items in A or B.
 
Top