TRIMRANGE & A4.:.A8 in Excel to exclude future rows
Brand new for Insiders is =TRIMRANGE which excludes empty data below your table and fixes the issue of having ugly 0s and errors when you drag down a formula beyond what is currently there to account for formulas being automated for future rows/columns.
The dot nation e.g. =B5.:.B8 can be used as an equivalent as TRIMRANGE to simplify formulas, I go through examples here and what doesn't at the moment work so well.
To download example workbooks, enter email here: https://www.xlconsulting-asia.com/soc...
00:00 Introduction
00:30 The problem
01:20 TRIMRANGE
02:18 XLOOKUP
03:53 SPILL errors
04:53 Dot notation
07:06 Row trim & col trim
08:51 Pivots & charts
10:23 Issues
11:12 Using Tables