Before we look at some examples of the AGGREGATE function in use ... notice that the result is a spilled array covering cells C1 and C2 because you told Excel to return the top two values.

Upgrade your Excel skills with smarter tools like XLOOKUP and dynamic arrays. Save time, reduce errors, and simplify complex ...

While using Microsoft Excel for data analysis, you may sometimes need to search for and retrieve specific values. In such ...

An curved arrow pointing right. {} These brackets mean something magical is happening inside your Excel formula. An "Array" function allows you to perform mathematical operations on many cells ...