Howdy,
in A2:A30 are several phrases that contain certain keywords. Keywords are F1:F8.
In B2:B30 I need a formula to every keyword phrases found in the A2:A30
Let's say the keywords are: house cat, table, sky
In A2 is the following sentence: The cat is in the house and play on the table.
In B2 formula should list: cat, house, table
In http://www.excelforum.com/showthread.php?t=1145804 it is a similar topic but list only one keyword .
Thank you in advance.
Last edited by Indi_Ra; 06-29-2016 at 04:39 PM.
Not pretty but:
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
daffodil11,
Thanks for formula.
Till appear a more beautiful formula, I have to use this one.
I'd still be curious if it could achieve another formula.
I did not put "solved". There may be a different formula.
Thank you in advance.
Are you willing/able to use a VBA function?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Yes. Thank you.Originally Posted by Tony Valko
Copy the VBA code at the link below and paste it into a general module:
https://www.excelforum.com/showthread.php?p=3096647
Then, this array formula** entered in cell B2:
=concatall(IF(ISNUMBER(SEARCH(F1:F8,A2)),F1:F8,""),", ")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Thanks Tony, I found there many useful UDF.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks