The PIVOTBY function is a dynamic array function in Excel that uses a formula to group rows and ... they're not a constant drain on your device's resources. Since PivotTables are a dedicated ...