MIN AND MAX Articles: Excel and Google Sheets

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...

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...

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...

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...

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...

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...

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...

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...

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:...

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...