The SUBTOTAL function in Excel is quite flexible. The single function allows you to perform 11 different calculations. In this post we will amend the custom function we have created to add an extra column plus headings.
Monthly Archives: May 2023
Humility does not mean you think less of yourself. It means you think of yourself less.
Ken Blanchard
SUBTOTAL and Dynamic Arrays in Excel – Part 3
The SUBTOTAL function in Excel is quite flexible. The single function allows you to perform 11 different calculations. In this post we will create a custom function to summarise a data set.
Don’t rush, but don’t wait. Act with urgency, but release yourself from the need to achieve it on a particular timeline. When you think longer term than most, you can think bigger than most. If it takes years, start now.
James Clear
SUBTOTAL and Dynamic Arrays in Excel – Part 2
The SUBTOTAL function in Excel is quite flexible and in this second post we build an automated summary report using SUBTOTAL.
Focus starts with elimination, improves with concentration, and compounds with continuation.
James Clear
SUBTOTAL and Dynamic Arrays in Excel – Part 1
The SUBTOTAL function in Excel is quite flexible. The single function allows you to perform 11 different calculations. It can also ignore hidden rows, something that not many Excel functions can do.
What if we studied what was right with people instead of what was wrong with them?
Don Clifton
Highlighting Weekends in Excel
When you have a list of dates in Excel it can be useful to know which of those dates are weekends. You can automate a format for weekends using a conditional format.