Row Labels: What a PivotTable Does, Rebuilt with UNIQUE and SORT
This lesson is part of the course
In this lesson
You build the row labels of a summary report for Brightwater Outdoor Co.: a sorted category list, a distinct count and a two-level Region / Category list, all with one formula each.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Row Labels: What a PivotTable Does, Rebuilt with UNIQUE and SORT Locked
- Values: SUMIFS over the Spilled Labels (H2#) Locked
- Cross-Tabs: Rows × Columns with UNIQUE, TRANSPOSE and One SUMIFS Grid Locked
- Show Values As: % of Grand Total, % of Row and % of Column Locked
- Count, Average, Max and Distinct Count: COUNTIFS, AVERAGEIFS, MAXIFS Locked
- Report Filters: Criteria Cells, (All) and a Drill-Down List Locked
- Grouping Dates by Month and Quarter: EOMONTH and Text Keys Locked
- Capstone: A Subtotal Report, a Summary that Ignores It, and a Chart Locked