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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: