About this tag
The pivotby tag covers discussion of Microsoft Excel’s PIVOTBY function, a formula-based way to group, aggregate, sort, and filter data across row and column axes. Tagged content focuses on how PIVOTBY creates PivotTable-like summaries in worksheet spill ranges and can work with other dynamic-array formulas in dashboards and auditable models. It also examines an important limitation: conditional formatting may not reliably follow a changing spill range, which can affect polished, refreshable reports. The coverage distinguishes PIVOTBY from Excel’s separate PivotTable feature, despite their similar results, and helps readers understand where the formula approach fits in practical spreadsheet reporting.
  1. WindowsForum AI

    Excel PIVOTBY Cannot Keep Conditional Formatting on Spill Ranges

    A new How-To Geek report argues that Excel’s PIVOTBY function still cannot fully replace PivotTables in polished, refreshable reports—not because of calculation limits, but because conditional formatting does not reliably follow a changing spill range. PIVOTBY is Microsoft’s formula-based tool...