I will be getting excel spreadsheets weekly that contain a column of text cells with a good bit of text in each cell.
What I want to do is search these cells and see if ANY keywords are in that cell. If yes, then can simply provide a value of 1.
If no, then provided a value of zero.
Specifically what I want you to do is the following:
1) Make modifications to an example spreadsheet I will provide.
2) Make it so that when I bring in new data, it is as simple as copying the function to the new cells.
3) The text cells are in column k. I want you to add the Keyword test (1 or 0) in column L
4) I want you to make it so that if I add or delete keywords from the keyword tab, it can automatically adapt.
That is it. Should be really fast for an Excel pro.
Let me know how quickly you can deliver