How to Count 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 kth largest value from a dataset based on its relative standing.

Example: You are working with the survey data, the age groups are in column A, and the responses are in column B.

Formula 1: To count the second largest value from the count of the responses (column B)

=LARGE(B2:B6, 2)

B2:B6 is the data range where we search for the values, and 2 is the second largest value. The result returns 54.

Formula 2: To count the third largest value from the count of the responses (column B)

=LARGE(B2:B6, 3)

B2:B6 is the data range where we search for the values, and 3 is the third largest value. The result returns 38.

Leave a Reply