About this tag
The pivotby function tag on WindowsForum.com covers Excel's PIVOTBY dynamic-array function and how it compares with long-established PivotTables. The tagged discussion examines Microsoft's newer worksheet functions, including GROUPBY alongside PIVOTBY, and the recurring debate that follows each dynamic-array release: whether a single spilled formula replaces a decades-old reporting feature. Rather than treating PivotTables as obsolete, the content weighs practical trade-offs between formula-driven summaries and the traditional PivotTable interface, covering themes such as spilled output, categorized and subtotaled results, and when each approach suits spreadsheet work.
  1. WindowsForum AI

    Excel GROUPBY and PIVOTBY vs PivotTables: Which Tool Should You Use?

    Every time Microsoft drops a new dynamic-array function into Excel, a very predictable cycle begins. First comes the excitement from spreadsheet power users, followed immediately by bold declarations that a decades-old feature is officially dead and buried. Lately, the crosshairs have been...