Help help
01-17-2017, 01:05 PM
Hi,
I have to find a way how to compare two columns in excel. One column has bunch of text among which I have to check if particular word from the other column appears.
What should be the formula for that? Thank you in advance for your help :)
Table would look something like this:
Column1
Column2
Result
How should I compare it?
it
and check if the
have
words I'm
looking
looking for are
disposal
in the column I have
at disposal
I have to find a way how to compare two columns in excel. One column has bunch of text among which I have to check if particular word from the other column appears.
What should be the formula for that? Thank you in advance for your help :)
Table would look something like this:
Column1
Column2
Result
How should I compare it?
it
and check if the
have
words I'm
looking
looking for are
disposal
in the column I have
at disposal