Recent Comments
Tag Archives: New functions
Regular Expressions in Excel
I recently discovered that Microsoft are working on Excel functions to work with Regular Expressions. A beta version is currently available to those on the “insider” program, but this functionality has long been available through VBA, and can also be … Continue reading
Posted in Excel, Link to Python, PyXLL, UDFs, VBA
Tagged Excel, New functions, Python, PyXLL, regular expressions, UDFs, VBA
Leave a comment
New GROUPBY and PIVOTBY functions
Microsoft recently announced two new functions that provide similar functionality to pivot tables, but will update automatically for any change in the referenced data. These functions are currently rolling out to users enrolled in the beta channel for Windows Excel and Mac Excel. … Continue reading
Posted in Computing - general, Excel
Tagged Excel, GROUPBY, myOnlineTraininghub, New functions, pivot tables, PIVOTBY, Slicers
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 