Recent Comments
Tag Archives: Selecting a trimmed range
More on TrimRange and the Drop Function
A comment on my previous post links to a helpful YouTube video on using TrimRange and the Dot operator: It also looks at using the Drop Function to exclude a specified number of rows and/or columns from the top or … Continue reading
Posted in Arrays, Excel
Tagged array functions, Drop function, Excel, Selecting a trimmed range, TrimRange function
Leave a comment
The TrimRange Function
I have just discovered the TRIMRANGE function, and its very useful shortcut version, which were introduced to Excel 365 about a year ago. The function excludes all empty rows and/or columns from the outer edges of a range or array, … Continue reading
Posted in Arrays, Excel
Tagged array functions, Excel, Selecting a trimmed range, TrimRange function
2 Comments
Newton Excel Bach, not (just) an Excel Blog 