+ Reply to Thread
Results 1 to 4 of 4

Find a multi string match in Column A

  1. #1
    Registered User
    Join Date
    02-26-2019
    Location
    New york
    MS-Off Ver
    MS office plus pro 2016
    Posts
    2

    Find a multi string match in Column A

    Hello everyone!

    I'm hoping you can help me with this.

    Problem:
    In Column A I have multiple strings, for example:

    1. 20D Fun 0L
    2. 10D Fun 0L
    3. 0L Fun 20D

    As you can see, 1. and 2. have the same information.

    Solution:
    Ideally I would like the formula to search Column A and find cells which have 3 matching strings. In Column B, the result should output the matching cell. For example, in the data I presented, the result for A1. would be A3.

    I appreciate any help.

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Find a multi string match in Column A

    You would need to share a workbook with more sample data than 3 rows (maybe 50-100), and show what you expect as your result for the data mocked-up.

    Go Advanced -> Manage Attachments -> Upload

  3. #3
    Registered User
    Join Date
    02-26-2019
    Location
    New york
    MS-Off Ver
    MS office plus pro 2016
    Posts
    2

    Re: Find a multi string match in Column A

    Quote Originally Posted by kersplash View Post
    You would need to share a workbook with more sample data than 3 rows (maybe 50-100), and show what you expect as your result for the data mocked-up.

    Go Advanced -> Manage Attachments -> Upload
    I've attached sample data and how I'd like the results to show. There only exists 1 duplicate for each cell but the strings are in different order.
    Attached Files Attached Files

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,036

    Re: Find a multi string match in Column A

    For your reference, we require you to disclose cross posts. I will do this for you this time, but in future you must do it yourself.

    https://www.mrexcel.com/forum/excel-...-matching.html

    https://www.excelguru.ca/forums/show...ch-in-Column-A
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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: 3
    Last Post: 10-19-2018, 05:45 AM
  2. Need help in multi criteria find and match value
    By alvin8866 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-21-2016, 08:20 PM
  3. nth occurrence of string in multi-column range
    By Gerralt_Tarrant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2014, 11:03 AM
  4. [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
  5. How to write macro for find and match particular string in a column
    By narendrabr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2012, 08:20 AM
  6. [SOLVED] How to limit multi-value (OR) FIND or SEARCH to the first or last word in a string?
    By Buzzed Aldrin in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-16-2012, 04:05 PM
  7. [SOLVED] Find a string match in a column
    By Matilda in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2006, 07:20 AM

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