2nd highest number in range in Excel

Q36. In Excel, how do I get the 2nd highest number in a range of numbers?

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) How can I fill a range of cells with incremental times?

2) How can I get the day number of the year for a date - for example 5 for Jan 5, 33 for Feb 2?

3) How can I quickly remove all blank cells in a data range?

4) How can I get an estimate of Standard Deviation of a sample dataset?

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

6) How can I find the count of records that meet a given condition in my raw data table?

7) How do I change the rating numbers to rating labels?

8) How can I convert Column numbers into Column names for use in range definition?

9) How can I find the sum of records that meet a given condition in my raw data table?

10) How can I remove hyperlinks from a range of cells?

11) How can I generate random numbers between 2 limits?

12) How can I find number of months that has elapsed given 2 dates?

13) In a Table , how can I add a Total Row that displays the maximum value in a column of numbers?

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

15) How can I find the count of records that meet multiple conditions in my raw data table?