Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Filling Blanks with Go To-Special (and local help rant)
- About Newton Excel Bach
- Cubic Splines
- Worksheetfunction.Transpose - changed behaviour in Excel 2013 and 2016
- Downloads
- Daily Download 5: Frame Analysis
- XLDennis, the MSDN Library, and VBA rant
- The history of the theory of beam bending - Part 1
Recent Comments
Tag Archives: PIVOTBY
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