Learn How to Get Last Match in Microsoft Excel
The main purpose of this formula is to get the position of the last match i.e. the last occurrence of a lookup value using the array formula. Here we will learn how to get the last match in the given data range in the workbook in Microsoft Excel.
That implies, with the help of a formula based on the MAX, INDEX, IF, ROW, and MATCH functions, you can able to get the position of the last match i.e. the last occurrence of a lookup value using an array formula.
So, with the help of this formula, you can able to get the last match in the given data range in the workbook in Microsoft Excel.
General Formula to Get Last Match
=MAX(IF(criteria,ROW(rng)-MIN(ROW(rng))+1))
The Explanation to Get Last Match
So we know that with the help of the given formula above, you can able to get the position of the last match i.e. the last occurrence of a lookup value using the array formula.
Here we will learn how to get the last match in the given data range in the workbook in Microsoft Excel. As we know, the purpose of this formula is that we build a list of row numbers for a given range, matching on a value, and then use the MAX function to get the largest row number, which corresponds to the last matching value.
We are using the named range “names” just for convenience. So now you have learned how to get the last match in the given data range in the workbook in Microsoft Excel.