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.