Main Profile

At A Glance

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

See how to create a dynamic array formula quickly using the Drill Through Method so that the sub table will automatically be populated with any new data added to the Master Sheet. See the functions: COUNTIF, IF, ROWS, INDEX, SMALL, ROW.See how to create a 3 dimensional table set up like in a database program.Extract Records Formula
Length: 11:33

Contact

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

Want more info about Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question