Results 1 to 8 of 8

Find all keywords

Threaded View

Indi_Ra Find all keywords 06-29-2016, 04:37 PM
daffodil11 Re: Find all keywords 06-29-2016, 04:54 PM
Indi_Ra Re: Find all keywords 06-29-2016, 05:10 PM
Tony Valko Re: Find all keywords 06-29-2016, 05:16 PM
Indi_Ra Re: Find all keywords 06-29-2016, 05:43 PM
Tony Valko Re: Find all keywords 06-29-2016, 06:12 PM
Indi_Ra Re: Find all keywords 06-30-2016, 02:24 AM
Tony Valko Re: Find all keywords 06-30-2016, 05:29 AM
  1. #1
    Banned User!
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    2013, 2016
    Posts
    318

    Find all keywords

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find if a text value contains one of the keywords
    By billj in forum Excel General
    Replies: 5
    Last Post: 02-22-2024, 01:07 AM
  2. [SOLVED] VBA looking for multiple keywords and return concatenated keywords, that were found
    By Kpacu007 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-10-2014, 06:03 AM
  3. How Do I find keywords and put it into template?
    By Snaybot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2014, 12:15 PM
  4. [SOLVED] Search for keywords and copy rows containing keywords to new sheet
    By lenorsk in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-15-2013, 06:54 AM
  5. [SOLVED] HDI - Return multiple keywords in a text column based on a set of available keywords
    By zneiley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2013, 01:32 PM
  6. Find duplicate keywords, and list maximum
    By undergraduate in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-13-2010, 10:29 PM
  7. where do i find a list of macro keywords
    By hecfrme in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2005, 08:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1