Hello
I'm new to this forum.
I've used Excel only for vanilla projects and I'm trying to do something more complicated.
I'd like to create a dynamic list of keywords - something I can change on occasion, and apply this list to column with text entries.
If any keyword from the list is contained within a cell's text, I'd like to copy another cell to the next column (in order to sum the new column).
I'm attaching a mock-up spreadsheet for illustration purposes.
Any ideas?
Thanks for your help.
Georgi
Bookmarks