How To: Create dynamic sub tables in Microsoft Excel

Create dynamic sub tables in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.

Life Hacks for Your Smartphone

Fresh tips every day.

1 Comment

This was very informative and I think I will try this with a few spreadsheets that I have to update.

How can I get in touch with you for assistance with a specific spreadsheet that I am having some problems with.


Share Your Thoughts

  • Hot
  • Latest