Learn How to Get Large With Criteria in Microsoft Excel
The main purpose of this formula is to return the largest values in a set of data with criteria. Here we will learn how to get large values with criteria in the given data range in the workbook in Microsoft Excel.
That implies, with the help of a formula based on the LARGE and IF functions, you can able to return the largest values in a set of data with criteria.
So, with the help of this formula, you can able to get the large value with criteria in the given data range in the workbook in Microsoft Excel.
General Formula to Get Large With Criteria
{=LARGE(IF(criteria,values),n)}
The Explanation to Get Large With Criteria
So we know that with the help of the given formula above, you can able to return the largest values in a set of data with criteria. Here we will learn how to get large values with criteria in the given data range in the workbook in Microsoft Excel.
As we know, the LARGE function is used to retrieve the “nth” largest value in a given numeric data range. In the example given here, we have to include only values associated with column B.
To perform this, we use the IF function to filter the values. So now you have learned how to get large values with criteria in the given data range in the workbook in Microsoft Excel.