Dynamic Array & Old Array Formulas to Create Student Classes Report – Excel Magic Trick 1608

Download Excel File: https://ift.tt/2lWBWDr
Learn how to create a report that shows each student by quarter with a list of classes in a single cell. See many of the new Excel 365 Functions like: SORTBY, UNIQUE, FILTER, TEXTJOIN and the ROWS Function. See how we can combine Spilled Arrays formulas and Old School Arrays Formulas together to make a report that automatically updates when new data arrives.

View on YouTube