Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
About the Author
Why Have a Book on Subtotals
Preparing Your Data and Adding Subtotals
How to Set up Your Data for Subtotals
How to Fit a Multiline Heading into One Cell
No Tiny Blank Columns Between Columns
How to Sort Data
Sort Days of the Week
Sort a Report into a Custom Sequence
Add Subtotals to a Data set
Subtotal Tricks & Techniques
Use Group & Outline Buttons to Collapse Subtotaled Data
Manually Apply Groups
Group Report Sections
Subtotals Above Each Group
Copy Just Totals from Subtotaled Data
Sort Largest Customers to the Top
Format the Subtotal Rows
Add Other Text to the Subtotal Lines
Subtotal One Column and Count Another Column
Subtotal by Month With Daily Dates
Subtotals by Product Within Region
Add a Page Break For each Group
My Manager Wants a Blank Line After Each Subtotal
Add a Calculation Only to the Subtotal Rows
Shift Subtotals One Column to the Right
Finding G/L Accounts Not in Balance
Why Is Final Subtotal Row Appearing After Many Blank Rows?
Enter a Grand Total of Data Manually Subtotaled
Why Does Subtotal Dialog Sometimes Default to Count?
Adding Subtotals to Dozens of Columns
Can You Get Medians?
Horizontal Subtotals
Subtotals Don't Work with Tables
Using the SUBTOTAL function without Invoking the Command
Adding a Total Visible Below a Filtered Data Set
Using 109 For Rows Manually Hidden
The 9 Basic Arguments
The 9 New Arguments
SUMIF or COUNTIF of Filtered Data
Introducing AGGREGATE
New Arguments for What to Ignore
New Arguments for AggregatE Function Number
Some Functions Require a Fourth Argument in AGGREGATE
How is SMALL or LARGE Different From MIN or MAX?
Doing MINIFS or MAXIFS Before They Existed
Using VBA with Subtotals
Creating Subtotals Using VBA
VBA & TEXTJOIN to Subtotal Dozens of Columns
Replacing Subtotals With Power Query
Using Power Query to Get #2 View of Subtotals
Index
← Prev
Back
Next →
← Prev
Back
Next →