+ Reply to Thread
Results 1 to 9 of 9

Search for a cell string in the same column and indicate match

Hybrid View

  1. #1
    Registered User
    Join Date
    10-16-2012
    Location
    Seoul, Korea
    MS-Off Ver
    Excel 2013, Excel 2016
    Posts
    14

    Re: Search for a cell string in the same column and indicate match

    Hi Dave,
    I don't understand why it is "Removed"!
    Would you explain please?

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2506
    Posts
    13,792

    Re: Search for a cell string in the same column and indicate match

    Yes.

    I thought I had solution. I realized that I missed some of the patterns you were expecting matches on. In particular Set 10 Set 6, Set 10 I could only return Set 10.

    Have been unable to find a way to resolve those that have matches mutually 'buried' in each other.

    I need to spend some time with this. Not as straight forward as I first thought. My apologies.
    Dave

  3. #3
    Registered User
    Join Date
    10-16-2012
    Location
    Seoul, Korea
    MS-Off Ver
    Excel 2013, Excel 2016
    Posts
    14

    Re: Search for a cell string in the same column and indicate match

    Oh snap!
    I think the error was at my end !

    After reading your reply, I rechecked my illustrated/expected solution and found error which I corrected now.
    Would you look at it again?

+ 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. Search column for string and date then search adjacent cell and pop up message
    By ftwobtwo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2014, 09:55 AM
  2. [SOLVED] Formula or Macro, match string,from 1 cell to a column,String use dash
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-07-2013, 06:03 PM
  3. Search for a text string and return adjacent cell value for each match
    By ral8088 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-21-2013, 09:55 AM
  4. [SOLVED] Search Column A and B for string match and return value of column C
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-18-2013, 10:02 AM
  5. [SOLVED] Search for String in Range, If Match, Return Matching Cell Value
    By ryanb909 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-21-2013, 02:27 AM
  6. [SOLVED] Vlookup, Match (Search or Find) partial string within string in a Cell
    By dluhut in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-28-2013, 12:40 PM
  7. [SOLVED] Search for string across header row, then search for another string down found column
    By TucsonJack in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2012, 02:09 PM

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