Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Intersections, interpolations, and rotations
- Linestgap with data in rows
- Frame Analysis with Excel - 3, Continuous beam or frame
- Combining text files
- Working with units in Excel - using VBA and Python
- Reinforced Concrete Section Analysis - 3
- The angle between two vectors, in 2D or 3D
- Biaxial bending update
- Reinforced Concrete Moment-Curvature - 1
- Daily Download 5: Frame Analysis
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