Results 1 to 2 of 2

Thread: Dynamic Sub-tables from Master - COUNTIF, IF, SMALL, INDEX, ROW, ROWS

  1. #1

    Dynamic Sub-tables from Master - COUNTIF, IF, SMALL, INDEX, ROW, ROWS



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am very much struggling with creating Dynamic Sub-tables from a Master.
    I basically want the column (Practice) to auto-populate sub-tables on different worksheets for each practice (here it is Board & HR, Manufacturing, etc.).
    The master looks like this:
    Master
    The sub-tables have the format:
    Sub-Tables
    The formula I am using is:
    =IF(ROWS(A$4:A4)>$E$1,"",INDEX(MASTER!A$2:A$300,SMALL(IF(Table1[Practice]=$B$1,ROW(Table1[Practice])-ROW(MASTER!$C$2)+1),ROWS(A$4:A4))))
    I have been using this youtube video as a framework:

    <iframe width="560" height="315" src="https://www.youtube.com/embed/tqCEY5YMyqw" frameborder="0" allowfullscreen></iframe>

    Any help would be much appreciated as I'm now completely stuck! The formula will not pick out the correct 'Practice' nor will it continue with drill through method on other worksheets!

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,721
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    CROSS POST


    This question has been posted in at least one other forum.
    Do not post any further responses in this thread until a link has been provided to these cross posts.

    Whilst we would rather you didn't cross-post, we know that there may be a valid reason for doing so. All we ask is that you provide the links in your original post to your question in the other forum(s). Read this to understand why: https://www.excelguru.ca/content.php?184

    This forum is full of volunteers that give up their own time to help others, something that should be respected and not taken for granted. It’s never nice for someone to find out that a problem they have spent time solving for you has already been answered somewhere else without them knowing, and so we ask you to make it clear that you have also asked elsewhere.

    Please update your original post to include the link(s).
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •