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
Showing posts with label Through. Show all posts
Showing posts with label Through. Show all posts
Sunday, October 7, 2012
Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through
Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through Tube. Duration : 11.55 Mins.
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
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
Subscribe to:
Posts (Atom)