Excel Forum
Similar Content
Name Worksheets Based on Cell Contents
Macro: This macro allows you to have your worksheets named by whatever is in a particular cel...
Find the Most Frequently Occurring Value in a List in Excel
Tutorial: Use a formula to return the most frequently occurring word or value from a range of cells...
Delete Entire Rows Based on Predefined Criteria (Text)
Macro: This macro will allow you to specify certain criteria and then to delete rows based up...



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





Got a Question? Ask it Here in the Forum.