| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| matching data in columns | Excel Discussion (Misc queries) | |||
| Matching two columns and their data | Excel Worksheet Functions | |||
| Matching Data in Columns | Excel Worksheet Functions | |||
| Matching data from 2 columns | Excel Worksheet Functions | |||
| How to take matching data from 2 columns and put in the same row? | New Users to Excel | |||
Linear Mode
