Results 1 to 7 of 7

Filter a column containing sentences with a column of words

Threaded View

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2011 Mac
    Posts
    25

    Filter a column containing sentences with a column of words

    Hi

    I have a column of sentences in A, and a list of words in column B. I want the sentences in column A to appear in another target column (for example column C) if a they contain a word (not case sensitive) that is in the list of words in column B, and I do not want the same sentence to appear more than once in the target column.

    Any ideas?

    Thanks

    Njaal, Norway
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove Stop Words from a column containing 16000 rows of sentences
    By Abhayrajify in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-30-2013, 07:14 PM
  2. Replies: 18
    Last Post: 11-29-2012, 07:43 AM
  3. Counting words in one column to count words in another column
    By stuart1133 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-16-2010, 05:54 AM
  4. List out words from sentences
    By ap_naveen in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-21-2010, 06:58 AM
  5. Split sentences into words
    By sparx in forum Excel General
    Replies: 5
    Last Post: 02-22-2006, 03:51 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