+ Reply to Thread
Results 1 to 3 of 3

Extracting Information from a Column based on Keyword Table

  1. #1
    Registered User
    Join Date
    03-25-2021
    Location
    London, England
    MS-Off Ver
    Office 16
    Posts
    1

    Extracting Information from a Column based on Keyword Table

    Hello,

    I need some help as I have not been able to find the answer to this problem online.

    Basically, I have a large number (thousands) of cells with miscellaneous information out of which I need to extract specific word combinations. In another sheet I have a table of these specific keywords (e.g. white chair). As this information is combined with other words that are noises (e.g. white chair, treat with sandpaper, not water resistant), I'm wondering if there is a formula or another way to use the keyword table to recognize the words within a column and then extract the recognized words into another column.

    I have been able to use a formula to recognize whether or not the word is within the cell but can't figure out a way to extract those words automatically as they are recognized. This would significantly speed up the process as I currently have to use the filtering or find and replace options, which is making this a very manual task.

    Thank you very much in advance!

    Helen

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Extracting Information from a Column based on Keyword Table

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,890

    Re: Extracting Information from a Column based on Keyword Table

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 04-19-2020, 06:16 AM
  2. [SOLVED] Userform: Add information into table based on row and column
    By Kyhosa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2019, 09:43 AM
  3. Replies: 3
    Last Post: 07-30-2017, 04:18 AM
  4. Extracting and comparing information from pivot table.
    By jonboy6257 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-14-2014, 06:14 PM
  5. Replies: 2
    Last Post: 07-13-2012, 04:02 AM
  6. extracting information from column to Another
    By walterw in forum Excel General
    Replies: 2
    Last Post: 06-27-2010, 05:28 PM
  7. Extracting Information from A Pivot Table
    By Jim Patterson in forum Excel General
    Replies: 2
    Last Post: 06-16-2006, 08:00 AM

Tags for this Thread

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