Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through

March 10, 2010 | By admin In Videos |

See how­ to create a dyn­am­ic array f­orm­ul­a q­uickl­y usin­g­ the Dril­l­ Throug­h M­ethod so that the sub­ tab­l­e w­il­l­ autom­atical­l­y b­e popul­ated w­ith an­y n­ew­ data added to the M­aster Sheet. See the f­un­ction­s: COUN­TIF­, IF­, ROW­S, IN­DEX, SM­AL­L­, ROW­. See how­ to create a 3 dim­en­sion­al­ tab­l­e set up l­ike in­ a datab­ase prog­ram­. Extract Records F­orm­ul­a

Other Related Posts:

10 Comments so far

  1. Anonymous on March 10th, 2010

    I am glad that you love this stuff! I love making the videos!

  2. Anonymous on March 10th, 2010

    Mike, this formula was so slick, my fingers kept slipping off my keyboard! Love this stuff!

  3. Anonymous on March 10th, 2010

    These three videso explain this type of formulas (inlcuding SMALL) much better:

    Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value …

    Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value …

    Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value …

  4. Anonymous on March 10th, 2010

    sorry, small formula ( in portugues is minor…)

  5. Anonymous on March 10th, 2010

    I’ll try and create an array formula to take a rabbit from a hat! If I can’t figure it out, I’ll ask someone at the Mr Excel Message Board!

  6. Anonymous on March 10th, 2010

    What do you mean by “minor formula”?

  7. Anonymous on March 10th, 2010

    That is sheer Magic!!! Mike is it possible to pull a rabbit out using an Array Formula??…….lol.
    Thanks! waiting for the next video!

  8. Anonymous on March 10th, 2010

    one more great vid…
    thank u
    I would like to understand the minor function in this formula, do u have a vid related with the minor formula?
    Keep going…

  9. Anonymous on March 10th, 2010

    Thanks! This was a fun vid to make because we got to do array formula and DrillDown!

  10. Anonymous on March 10th, 2010

    woo 7 views ..first comment :D

    Nice vid! *rate*

Leave a reply