Results 1 to 4 of 4

Retrieving multiple text strings based on multiple criteria (formula update)

Threaded View

McKneezy Retrieving multiple text... 03-19-2019, 03:12 PM
FDibbins Re: Modification of a formula 03-20-2019, 12:22 AM
McKneezy Re: Modification of a formula 03-21-2019, 01:28 PM
JeteMc Re: Retrieving multiple text... 03-24-2019, 08:52 PM
  1. #1
    Registered User
    Join Date
    10-09-2018
    Location
    Montreal, Canada
    MS-Off Ver
    2016
    Posts
    87

    Retrieving multiple text strings based on multiple criteria (formula update)

    Hello,

    If anyone can assist me that would be great.

    Summary
    The enclosed file has an old desired result to extract certain information. Currently there are ID's (Column A) that withdraw FROM (Column C to E) a program TO (Column F to H) another program. More than one withdrawal can occur in any year (Column B), hence why there is three columns for FROM and TO, as there can be up to three withdrawals in any year.

    What I would like to achieve (desired results in attachment)
    Explained in attachment

    Thanks in advance,

    Rob
    Last edited by McKneezy; 03-20-2019 at 10:13 AM. Reason: Modification of title for clarification purposes

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Modification in formula
    By aligahk06 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-03-2019, 04:15 AM
  2. [SOLVED] Formula Modification
    By hammer2 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-20-2015, 09:25 PM
  3. [SOLVED] If/then formula modification
    By quibilty in forum Outlook Formatting & Functions
    Replies: 6
    Last Post: 06-21-2015, 08:47 AM
  4. [SOLVED] IF Formula Modification.
    By tomvh444 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-24-2015, 04:44 PM
  5. If/and formula modification
    By quibilty in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-28-2013, 04:46 AM
  6. Formula Modification
    By quibilty in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-14-2013, 01:25 AM
  7. Modification of formula with If(Or)
    By rhudgins in forum Excel General
    Replies: 2
    Last Post: 10-17-2011, 01:11 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