+ Reply to Thread
Results 1 to 2 of 2

Extracting multiple strings from a table based on multiple criteria

  1. #1
    Registered User
    Join Date
    10-09-2018
    Location
    Montreal, Canada
    MS-Off Ver
    2016
    Posts
    87

    Extracting multiple strings from a table based on multiple criteria

    Hello there,

    Please see sample workbook that clearly explains the desired results.

    Note that this is just sample as part of a larger data set.

    Thank you!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Extracting multiple strings from a table based on multiple criteria

    Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

    Thanks again for all your hard work here!
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. [SOLVED] Extracting a text field based on multiple criteria
    By McKneezy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2019, 12:08 PM
  2. VBA - Extracting unique data based on multiple criteria
    By donjamin in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-18-2019, 06:50 AM
  3. [SOLVED] Retrieving multiple text strings based on multiple criteria (formula update)
    By McKneezy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2019, 08:52 PM
  4. [SOLVED] lookup multiple cells with corresponding multiple criteria based on one table
    By eligt in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-12-2018, 06:02 AM
  5. Extracting all programs from a table with multiple criteria
    By McKneezy in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-06-2018, 12:18 PM
  6. Extracting rows of data based on multiple criteria from a list
    By cnak in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-04-2018, 12:10 PM
  7. [SOLVED] Extracting certain rows based on multiple criteria
    By Nurik in forum Excel General
    Replies: 6
    Last Post: 10-30-2013, 02: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