Excel - The TRIMRANGE Function

By Andrew Gould Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/trimrange-trim-ref/ Learn how to use the TRIMRANGE function and Trim Ref notation to reference empty cells in your dynamic array formulas without producing answers for those cells until they are filled in. You learn how to control the trimming of rows and columns, how to use Trim Ref notation to make your trimmed ranges more succinct, and how to apply these techniques to a range of Excel formulas and functions. If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel by clicking the following link: https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! Chapters 00:00 Topic List 00:39 A Basic Dynamic Array Formula 01:38 Referring to More Cells 03:21 The TRIMRANGE Function 05:01 Optional Parameters 06:32 Trimming Horizontal Ranges 08:08 Options for Trimming Columns 08:54 Completing the Example 10:44 The Trim Ref Notation 13:01 Using Trim Refs in Other Functions 16:36 One More Example Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!