All resources related to MIN AND MAX for Excel and Google Sheets.

nth largest value with duplicates

If you have a data set with duplicates, and you want to get ‘nth largest value,’ use MAX together with IF functions. NOTE: the LARGE function may not work if the nth values exist in the data since it will return duplicates. Generic Formula =MAX(IF(rng<A2,rng)) where (rng) is the range...

nth largest value

If you have a set data and you want to get the 2nd, 3rd, 4th,….nth largest value, you can use the LARGE function. This is a function that can help you to select a value (s) in a list based on their standing. The formula is straightforward in application. Generic...

Minimum value

If you have a set of data or numbers and you want to get a minimum value in excel, the MIN function would be the perfect formula. The applicant of the function or the formula is straightforward. Generic Formula: =MIN(range) Example Application The best application example of this formula is...

nth largest value with criteria

Excel offers some cool features to work with numbers. One of these is to find the nth largest value with criteria. Say, you have some numbers. With the help of Excel you can find the 2nd or 3rd largest number among them that satisfies a criteria. You can do it...

nth smallest value

Excel offers some cool ways to analyze data. One such tool is to find the nth smallest value from a data. It can be daunting to find the 2nd or 3rd smallest value manually if you have a large data set. However, Excel can help us to do that very...

How to Get the Maximum in Excel IF There Are Multiple Criteria

We can get the maximum value of a dataset without considering any criteria by simply using the MAX or LARGE function in Excel. But what if we need to consider one or multiple criteria to get the maximum value? In this article, we will learn how to get the maximum...

Minimum if multiple criteria

We use the MIN function to return the minimum value in a range of cells in Excel. But if we want to return the minimum or lowest value based on single criteria then we use the MIN function with IF function in an array formula because there is no built-in...

How to Get Minimum Value If Criteria Match in Excel

To return the lowest value from a range of cells we use the Excel MIN function. But, if we need to get the minimum value based on criteria then Excel does not have a built-in function for that. However, we can return the minimum value if criteria match by using...

Max value ignore all errors

We can use the AGGREGATE function to calculate the maximum numerical value in a set of values full of errors. We can calculate the maximum value from the data using max value ignore all errors task through Excel Aggregate function. The steps below will walk through the process. Figure 1:...

nth smallest value with criteria

We can use a particular criteria to get the nth smallest value in excel. What we are required to do is provide our particular criteria and then use an array formula that is based on SMALL and IF functions. This post provides a clear guide on how to get the...