chanccl
05-07-2021, 03:12 AM
Dear Expert,
I want to compare with two column A and B and find any match word(s).
This is an apple
apple is red
best friend
this is the one
lets go
my friend
cup of water
For example, base on column A "This is an apple" compare to each cell in column B. any match word will highlight it. or return true/false on column C.
Please help on this with many thanks!
chanccl
I want to compare with two column A and B and find any match word(s).
This is an apple
apple is red
best friend
this is the one
lets go
my friend
cup of water
For example, base on column A "This is an apple" compare to each cell in column B. any match word will highlight it. or return true/false on column C.
Please help on this with many thanks!
chanccl