Recent Comments
Tag Archives: CSE array functions
Dynamic array update and the @ operator
Many of the user defined functions (UDF’s) presented in this blog return an array rather than a single value. Options for displaying arrays in Excel have changed significantly in recent years and this post looks at the most efficient ways … Continue reading
Posted in Arrays, Excel, Link to Python, PyXLL, UDFs, VBA
Tagged @ operator, array functions, CSE array functions, dynamic arrays, Excel, Implicit Intersection Operator, PyXLL, UDFs, VBA
1 Comment
Excel Dynamic Arrays
Previews of dynamic arrays in Excel have been available for some time through the “Insider” programme. They are now being published to general subscribers through Office 365 monthly updates: Further information is given at: Easier array formulas and Dynamic array … Continue reading
Posted in Arrays, Excel, UDFs
Tagged array functions, CSE array functions, dynamic arrays, Excel, UDFs, VBA
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 