In this article:

Find the Second Highest Value in Google Sheets (2024 Guide)

May 8, 2024

How to Find the Second Highest Value in Google Sheets

To find the second highest value in a range of cells in Google Sheets, you can use the LARGE function. This function allows you to specify a range of cells and then return the nth largest value within that range. To get the second highest value, you would set n to 2.

Here's how to do it:

Step 1: Identify Your Data Range

Determine the range of cells containing the numbers from which you want to find the second highest value.

Suppose your data in cells A1 through A10 are as follows:

10

20

30

40

50

60

70

80

90

100

Here's what it looks like in Google Sheets:

google sheets find second highest value

Step 2: Select the Cell for the Result

Click on the cell where you want the result of the second highest value to appear. This can be any empty cell in your sheet. For this example, let's use C1.

google sheets second highest value

Step 3: Enter the LARGE Function

In cell C1, you're going to type the LARGE function formula. It follows this format:

=LARGE(range, n)

where the range is the group of cells that contain the data you're analyzing, and n is the position of the value you want to find (2 for the second highest value).

second highest value google sheets

Based on our example, you will enter:

=LARGE(A1:A10, 2)

This formula tells Google Sheets to look in cells A1 through A10 and return the second largest number found in that range.

After entering =LARGE(A1:A10, 2) in cell B1 and pressing Enter, the result displayed in C1 should be 90 since 90 is the second highest value in our example. 

We hope that this article has helped you and given you a better understanding of how to find the second highest value in Google Sheets! If you enjoyed this article, you might also like our articles on how to do a factorial in Google Sheets and how to find the max value in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->