Excel Dynamic Arrays: Accounting: Dynamic Schedule of Accounts (Excel Magic Trick 1530)

Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1530-1531.xlsx
In this video learn how to create a dynamic Schedule of Accounts based on an Expenses Category Formula Inpout. When we change the Expenses Category, a new report appears.
In this video see these Excel Features:
SORT Array Function
UNIQUE Array Function
Data Validation List Dropdown
FILTER Array Function
SEQUENCE Array Function
COUNTIFS Function
IF Function
ROWS Function
SUMIFS Function
Conditional Formatting
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm
Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *