2nd highest number in range in Excel

To do it in Excel, here is the answer:

a) Enter the formula =LARGE(W3:AA12,2) as shown below where W3:AA12 corresponds to the range that has the numbers.

The second argument 2 corresponds to the position (in this example 2nd highest). This argument could take any value from 1 to the total count of numbers in range.

In case kth lowest number is required, replace "LARGE" in formula above with "SMALL".

excel 2nd highest number in range


You can find similar Excel Questions and Answer hereunder

1) Is there a way to easily shade alternate rows in a data range for improving readability?

2) How can I find the number of working days between 2 dates given a holidays list?

3) How can I get row count of filtered data?

4) Sumifs with date range as criteria in Excel

5) How can I clear all formats (formats alone not data) from a range of cells?

6) Is there a way I can average a range of numbers even if there is an error value in range?

7) How do I get the rank of a number in a list of numbers?

8) Can I apply formatting to a number concatenated with a Text?

9) How can I fill a range of cells with incremental times?

10) Concatenate number with text but keeping in number format in Excel


Here the previous and next chapter