Results 1 to 17 of 17

Find one or more words in another column that could have one or more words

Threaded View

  1. #1
    Registered User
    Join Date
    07-24-2007
    Posts
    66

    Find one or more words in another column that could have one or more words

    I just inheriited a spreadsheet with over 30,000 rows with Quote Names and within those quote names is always the Retailer name. When we give our customer a quote number for a discount to give their customer (the retailer) we put the year, quote code, retailer name and length in it. For example "2017 - Q325% - Wal-Mart - 6MO" is a typical quote number we give to customers.

    What I'm trying to do is find any new Quote Numbers that I need to track, so once a week I need to comb through all the current quote numbers to find all the new ones. So I've been able to filter out all the current ones I track by using a vlookup, but finding new ones is difficult.

    What I have is a list of all the Retailers we track: Wal-Mart, Kroger, Meijer, Home Depot and so on and once a week when I pull current quotes from MSBI new quotes show up but the retailer is always in the middle of the quote so I haven't been able to find a way to find the retailer in the new quotes and give a True or False Result.

    Tab 1 Column A Tab 2 Column A Result needed
    Wal-Mart 2017 - Q325% - Meijer - 6MO TRUE
    Kroger 2017 - Q305% - Home Depot - 6MO TRUE
    Meijer 2017 - Q355% - Steinmart- 6MO FALSE
    Home Depot 2017 - Q325% - Wal-Mart - 6MO TRUE

    Formula I've tried and all variations I can think of:
    =countif(Tab1 A:A,Tab2"*"&A1&"*")>0

    That formula would work if the Retailer name was at the end or beginning, but it never is and the character length isn't the same due to the Retailer names being different lengths.

    Thanks for any help you can give!
    Last edited by amy22x3; 11-03-2017 at 09:12 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. adding more tags (words) to a column that already has tag words ?
    By jitterbug888 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-04-2016, 07:02 AM
  2. how can i copy/paste the word which is found during search in the current row wise
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2014, 02:55 AM
  3. Macro to only keep 100 words in a range of single words per column
    By PiaHarrison in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-03-2014, 08:57 PM
  4. Replies: 3
    Last Post: 11-28-2012, 04:00 AM
  5. Replies: 4
    Last Post: 04-27-2012, 06:38 AM
  6. Replies: 1
    Last Post: 04-04-2012, 07:15 PM
  7. [SOLVED] how do i insert words into a column without erasing the words
    By soccer5585 in forum Excel General
    Replies: 0
    Last Post: 06-08-2005, 07: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