I have a list of keywords in an Excel file.
I need to create a workflow that uses the list of keywords to search through a large table and highlight every record in the table that mentions any of the keywords.
Keywords |
Machine Learning |
Greenhouse |
Sample Data Set
Project ID | Project Name |
1001 | Coca Cola Pursuit |
1002 | GNC Machine Learning Pursuit |
1003 | Disney Greenhouse Machine Learning Deal |
1004 | Yeti Machine Learning Deal |
1005 | HP Record |
Desired Output
Project ID | Project Name | Matches |
1001 | Coca Cola Pursuit | NA |
1002 | GNC Machine Learning Pursuit | Machine Learning |
1003 | Disney Greenhouse Machine Learning Deal | Greenhouse, Machine Learning |
1004 | Yeti Machine Learning Deal | Machine Learning |
I've tried to use the find and Replace tool but this gets tricky when when one record matches more than one keyword.
Any help would be greatly appreciated!
This is great, thank you!