Excel Magic Trick 1340: Create Expandable Range in an Excel Table (2 Methods)

About this tutorial:

Video duration: 00:06:38
Download Files:

Start File and Finished File:

Download File:

See how to create expandable range in an Excel Table as part of a COUNTIFS formula that calculates a running count of names as there are entered into the table:
1. (00:12) Introduction
2. (00:35) Example of how Normal Expandable Range will NOT work
3. (02:44) INDEX Formula solution
4. (05:19) Expandable Range made with One Mixed Cell Reference (First Cell in Range) and Table Formula Nomenclature (Structured…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads