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.

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