YouTube home Register to vote
Upload

Loading...

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

101,533 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Mar 5, 2010

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

Loading...

Advertisement
to add this to Watch Later

Add to

Loading playlists...