• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pull some words from a sentences in a range basis some keywords list

M

msharma864512

Member
I want to pull certain keywords from a sentence basis some list of keywords.

For e.g. Cell A3 has a sentence: "Sumit has consulting experience". Cell B3 should return Consulting. Similarly in other rows there would be different sentences with different keywords, and separate sheet would have list of keywords which I would want to return from column A.

Details are in the attachment.

Manish
 

Attachments

  • Pull Keyword from a range basis some criterias.xlsx
    10 KB · Views: 3
See attached formula in cell B3:
Code: 
=TEXTJOIN(", ",TRUE,FILTER(Keywords[Keyword],NOT(ISERR(SEARCH(Keywords[Keyword],A3))),"None"))
Your keywords list has been made into a proper Excel Table.

1712139966501.png
 

Attachments

  • Chandoo56564Pull Keyword from a range basis some criteria.xlsx
    12.1 KB · Views: 2
You must log in or register to reply here.
Back
Top