matching 2 columns of data
 

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

matching 2 columns of data
 

Put in C1 and copy down column c

=If(A1=B1, B1, "")

karen wrote:

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

matching 2 columns of data
 

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.

"Bob I" wrote:

Put in C1 and copy down column c

=If(A1=B1, B1, "")

karen wrote:

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

matching 2 columns of data
 

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.

karen wrote:

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.

"Bob I" wrote:


Put in C1 and copy down column c

=If(A1=B1, B1, "")

karen wrote:


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