-
Compare with two column and return value or highlight match word(s)
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
-
-
What is the maximum amount of rows you would have in both Column A and Column B?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules