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 …