In column A I have a list of 500 words.
In column B I have a list of 300 words.
In column C I want to list all the words that column A and B have in common. As seen in the example below.
<tbody>
</tbody>
Thanks for your help!
In column B I have a list of 300 words.
In column C I want to list all the words that column A and B have in common. As seen in the example below.
elephant | crocodile | elephant |
rat | mosquito | |
circus | elephant |
<tbody>
</tbody>
Thanks for your help!