New Excel TRIMRANGE Function Explained
Download the example/practice file here: https://www.myonlinetraininghub.com/excel-trimrange-function
👩🏫 Master Excel with my courses: https://bit.ly/trimrange24courses
▶️ Learn more about the BYROW function: https://youtu.be/8-ANSpXcHr0
There's a new function just released in the beta version of Excel that will save you a ton of time. It's called TRIMRANGE! It’s nothing like the TRIM function.
TRIMRANGE automatically detects the cell range your data occupies and expands and contracts with it. You no longer need to write dynamic named range formulas with OFFSET or INDEX.
There’s also a new dot operator shorthand for TRIMRANGE that simplifies referencing dynamic ranges even further.
It’s got the Excel fans on Reddit excited about how this new functionality will simplify and streamline formulas.
TRIMRANGE is still in preview, so keep in mind that the syntax and functionality may change before it’s generally available.
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up
🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
#Excel #ExcelFunctions #TRIMRANGE