Results 1 to 4 of 4

Find matching words in a text string and return one of four words

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2018
    Location
    Ottawa
    MS-Off Ver
    Office 365
    Posts
    57

    Find matching words in a text string and return one of four words

    I would like to find a way to simplify some work in classifying post-secondary institutions by one of four types. I have created a sample worksheet with the four ranges I am using, but cannot figure out the equation for the desired output which I have included.

    I think that I was able to upload the file, but cannot see it on this page.
    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. How to compare text of same row in two different columns and return matching words?
    By guest2013 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2015, 03:22 PM
  2. Replies: 15
    Last Post: 10-12-2014, 08:53 AM
  3. Replies: 1
    Last Post: 07-02-2014, 12:02 PM
  4. Which function to find a words in word string and return them
    By majo. in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-27-2013, 09:08 AM
  5. [SOLVED] Find matching words in 10 columns and add row numbers of matching words
    By zeke 29 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-03-2012, 09:57 AM
  6. Replies: 4
    Last Post: 04-27-2012, 06:38 AM
  7. Replies: 1
    Last Post: 04-04-2012, 07:15 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