Excel Magic Trick 1340

Create Expandable Range in an Excel Table (2 Methods)


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:
(00:12) Introduction
(00:35) Example of how Normal Expandable Range will NOT work
(02:44) INDEX Formula solution
(05:19) Expandable Range made with One Mixed Cell Reference (First Cell in Range) and Table Formula Nomenclature (Structured Reference) Relative Cell Reference (Second Cell in Range).
(06:21) Summary


Download “Excel Magic Trick 1321-1340” Excel-Magic-Trick-1321-1340.zip – Downloaded 909 times – 98 MB

Be the first to comment

Leave a Reply