Microsoft Excel

Learn How to Get nth Largest Value With Duplicates in Microsoft Excel

Learn How to Get nth Largest Value With Duplicates in Microsoft Excel

The main purpose of this formula is to get the nth largest value in a data set with duplicates. Here we will learn how to get the nth largest value with duplicates in the given data range in the workbook in Microsoft Excel.

That implies, with the help of a formula based on the MAX and IF functions, you can able to get the nth largest value in a data set with duplicates.

So, with the help of this formula, you can able to get the nth largest value with duplicates in the given data range in the workbook in Microsoft Excel.

 

General Formula to Get nth Largest Value With Duplicates 

=MAX(IF(rng<A2,rng))

 

The Explanation to Get nth Largest Value With Duplicates

Learn How to Get nth Largest Value With Duplicates in Microsoft Excel

So we know that with the help of the given formula above, you can able to get the nth largest value in a data set with duplicates. Here we will learn how to get the nth largest value with duplicates in the given data range in the workbook in Microsoft Excel.

As we know, that LARGE function is fully automatic, and it will easily return nth values, but LARGE will return duplicates when they exist in the source data. The MAX function is used to get the large value first; once the largest value is established, we create another formula that simply checks all values against the “last largest value.”

So now you have learned how to name the nth largest value with duplicates in the given data range in the workbook in Microsoft Excel.