SUBTOTAL and Dynamic Arrays in Excel – Part 4

Post author:Neale Blackwood
Post published:30/05/2023
Post category:Custom Functions Dynamic Arrays Excel Blog LAMBDA
Post comments:2 Comments

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.

(more…)

SUBTOTAL and Dynamic Arrays in Excel – Part 3

Post author:Neale Blackwood
Post published:23/05/2023
Post category:Custom Functions Dynamic Arrays Excel Blog Functions LAMBDA
Post comments:0 Comments

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.

(more…)

SUBTOTAL and Dynamic Arrays in Excel – Part 2

Post author:Neale Blackwood
Post published:16/05/2023
Post category:Dynamic Arrays Excel Blog
Post comments:0 Comments

The SUBTOTAL function in Excel is quite flexible and in this second post we build an automated summary report using SUBTOTAL.

(more…)

SUBTOTAL and Dynamic Arrays in Excel – Part 1

Post author:Neale Blackwood
Post published:09/05/2023
Post category:Dynamic Arrays Excel Blog Functions
Post comments:2 Comments

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.

(more…)

Highlighting Weekends in Excel

Post author:Neale Blackwood
Post published:02/05/2023
Post category:Excel Blog Functions
Post comments:0 Comments

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.

(more…)