amitinddr1
New Member
- Joined
- Sep 15, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
I have a column A that contains some data. Each cell in column A represents a set of keywords. I want this to compare with column B, which contains similar set of keywords, but the keywords could be more or less AND can be at different row. I want C2 to list down the keywords that were found common in A2 when compared to all the rows of column B. Below is an illustration of what I need. I need a formula that can be also used on Google Sheets. I am not an Excel expert and any kind of help will be greatly appreciated.
Thanks
Amit
Thanks
Amit