Fusing LARGE Function with INDEX-MATCH to Find the Highest or Largest Three Read More: How to Use INDEX MATCH with Multiple Criteria in ExcelĢ. ➤ Finally, the AGGREGATE function ignores all the Error Values & extracts the largest value from the array. The dividend or numerator part returns an array with all prices from the list & it looks like. ➤ In the 3rd argument, a complex array has been established. ➤ 6 has been chosen as Option Number which ignores the Error Values. ➤ Inside the array, 14 is the Function Number that is assigned to the LARGE function. ➤ Press Enter & you’ll get the maximum price of Compufy notebook at once. We’re going to determine the highest price of the notebook of Compufy brand. Returns an aggregate in a list or database. serial number or position in the array based on the return values Options- An option to choose that will ignore the error or numerical data.Īrray- Selected array or range of cells where the formula will work You have to select the function required with the serial number.

=AGGREGATE(function_num, options, ref1, ref2, ,…)įunction_num- A list of 19 functions with serial numbers will appear. =AGGREGATE(function_num, options, array, ) Let’s get introduced to the AGGREGATE function first before applying the function in this section. Combining INDEX, MATCH & AGGREGATE Functions to Determine Maximum Value with Multiple Criteria

Read More: How to Use INDEX MATCH with Multiple Criteria for Date RangeĪlternative Methods to INDEX, MATCH & MAX Functions 1.

Now if we want to extract the model name, device type & brand name for that particular date of manufacture, then we have to simply change the column number for the INDEX function based on the criteria position in the array. ➤ Press Enter & now you’ll find the latest date among all instantly.Īs the dates are present in the 4th column of the selected array, we’ve assigned the column number of the INDEX function as 4.

Index match