+ Reply to Thread
Results 1 to 4 of 4

Creating a formula in a table that satisfies multiple assumptions

  1. #1
    Registered User
    Join Date
    09-16-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    2

    Creating a formula in a table that satisfies multiple assumptions

    Hello, I am struggling to create a formula that would satisfy some dynamic assumptions. Here is what it looks like. I would appreciate your comments.




    Formula.xlsx

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Creating a formula in a table that satisfies multiple assumptions

    Here's an option, In B7 copied across and down

    =IFERROR(IF(COLUMNS($A$1:A$1)-MATCH("Launch",$B7:$I7,0)<0,"",INDEX($B$4:$I$4, COLUMNS($A$1:A$1)-MATCH("Launch",$B7:$I7,0)+1)),"")
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Creating a formula in a table that satisfies multiple assumptions

    Quote Originally Posted by ChemistB View Post
    Here's an option, In B7 copied across and down

    =IFERROR(IF(COLUMNS($A$1:A$1)-MATCH("Launch",$B7:$I7,0)<0,"",INDEX($B$4:$I$4, COLUMNS($A$1:A$1)-MATCH("Launch",$B7:$I7,0)+1)),"")
    Minor correction here, looks like this formula goes into B13, not B7. I noticed the sample has the B13:I15 table formatted as text, be sure the change the formats to "General" or the formula will not calculate!
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  4. #4
    Registered User
    Join Date
    09-16-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    2

    Thumbs up Re: Creating a formula in a table that satisfies multiple assumptions

    THANK YOU ChemistB and Speshul

+ 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] formula that satisfies two conditions and search the name
    By jpgmaas in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-22-2013, 06:09 AM
  2. [SOLVED] formula that satisfies two conditions and search the name on the other tab.
    By jpgmaas in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-29-2013, 03:54 AM
  3. Figuring out a number that satisfies a certain formula
    By DoolinDalton in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 09-30-2009, 12:58 PM
  4. Formula to select value that satisfies conditions
    By bmind in forum Excel General
    Replies: 10
    Last Post: 04-03-2009, 11:07 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