How to Calculate the Second Largest Value

You can calculate the maximum value with the Max function, but to calculate the second or third largest values, you will need to use the LARGE function.

The LARGE function returns the k-th largest value from a dataset based on its relative standing.

To calculate the second largest value from the data range, please use the formula below:

=LARGE(B2:B6,2)

Where B2:B6 is the data range.

To calculate the third largest value from the data range, please change the number 2 to 3.

=LARGE(B2:B6,3)

Leave a Reply