This page contains a video on the AGGREGATE Function in Excel. It is an introductory video that lasts about 15 minutes. The purpose of the video is to show you what the function does and to demonstrate the Reference and Array forms of the function.

I have also attached my AGGREGATE.xlsx file to this page that you should open alongside the video.

The xlsx file contains a feature that I have seen nowhere else that will help you to choose which of the reference and array forms you should use.

Here’s the Exel file … aggregate

Here’s the video file … 

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: