matching 2 columns of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index/match across multiple columns? 19
Match 2 fields in 2 seperate Spreadsheets and fill another column 1
vlookup challenge with hyphen data placement 2
Reference Formula Help 1
how do I excel 0
comparing 2 columns for matches 2
Formula Help - Lookup, if, iserror?? 9
Match 3

Back
Top