Results 1 to 3 of 3

Automatically Generated list based on criteria

Threaded View

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

    Re: Automatically Generated list based on criteria

    First I set up key columns (Col H) on Actual and Schedules Sheets using this formula (example from Actuals!H2)

    =IF(A2=Sheet2!$C$3, IF(Sheet2!$J$3="", IF(Sheet2!$F$3=C2,H1+1,H1), IF(Sheet2!$J$3=D2, H1+1, H1)),H1)

    This counts off all the rows that match your criteria from Sheet2

    Then on Sheet2 in B8 for example, I use INDEX/MATCH to pull back the values in each row where the values increment in Col H

    =IF(MAX(Actuals!$H:$H)>=ROW(A1),INDEX(Actuals!$C$2:$C$13,MATCH(ROW(A1),Actuals!$H$2:$H$13,0)),"")
    See attachment
    Questions?

    Important Edit. Need to change that initial
    MAX(Actuals!$H:$H)>ROW(A1) TO MAX(Actuals!$H:$H)>=ROW(A1)
    for all columns.
    Otherwise, you'll not include your last value.
    Attached Files Attached Files
    Last edited by ChemistB; 03-21-2013 at 03:48 PM. Reason: Formula Error
    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

Thread Information

Users Browsing this Thread

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

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