I have a list of titles that I would like to see if these titles appears in another cell. Can anyone help?
Here is the example:
A1
Manager
Assistant Manager
Manager, II
VP
Vice President, Sales
Assistant
Associate
I would like to see if it appear in this cell, regardless where it is the exact text match
B1
Manager, Assistant, VP, Sales
So the result will be like:
Screenshot_1.png
Thanks!
Bookmarks