Combining Columns

[mgxdigital]

Hello,

I'm wondering if it's possible to find the matches between 2 columns and insert them into a new 3rd column.

For instance, I have 2 columns right now that each have 200 items. I'd like a new 3rd column to tell me which item is in both columns.

Column 1 / Column 2 / Column 3 (which shows matches)

Apple / Pear / Apple
Orange / Peach / Pear
Peach / Strawberry
Banana / Apple

Thoughts? I hope this is possible

[Fotis1991]

Hi

For just know which are in both columns, use in C1, this formula and copy down.

=COUNTIF($A$1:$A$5;B1)

Data range A1:B5, IN THE EXAMPLE.

result=1, is for both columns and =0 for just one column.

[mgxdigital]

Thanks for replying.
I can not get this to work.
Column A has 592 values and column B has 1560 values.
I'd love to put a 1 next to the value in column A that is also in column B.
Thoughts?

[Fotis1991]

Does it helps you??

[mgxdigital]

Thanks for replying.
I can not get this to work.
Column A has 592 values and column B has 1560 values.
I'd love to put a 1 next to the value in column A that is also in column B.
Thoughts?

[Fotis1991]

Thanks for replying.
I can not get this to work.
Column A has 592 values and column B has 1560 values.
I'd love to put a 1 next to the value in column A that is also in column B.
Thoughts?

.... Same answer in your post #3 & #5

Ok i understoond it, so i upload for you an example(post#4), that does, what are you want.

Did you look at it??