Find all keywords

**Indi_Ra** · 06-29-2016, 05:10 PM

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.

**Tony Valko** · 06-29-2016, 05:16 PM

Are you willing/able to use a VBA function?

**Indi_Ra** · 06-29-2016, 05:43 PM

Originally Posted by Tony Valko

Are you willing/able to use a VBA function?

Yes. Thank you.

**Tony Valko** · 06-29-2016, 06:12 PM

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.

Find all keywords

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Find all keywords

Re: Find all keywords

Re: Find all keywords

Re: Find all keywords

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find if a text value contains one of the keywords

[SOLVED] VBA looking for multiple keywords and return concatenated keywords, that were found

How Do I find keywords and put it into template?

[SOLVED] Search for keywords and copy rows containing keywords to new sheet

[SOLVED] HDI - Return multiple keywords in a text column based on a set of available keywords

Find duplicate keywords, and list maximum

where do i find a list of macro keywords

Bookmarks

Bookmarks

Posting Permissions