Second Maximum Value In Excel

A very common interview question that is asked in an excel interview is to find the second maximum value in a row.

Let’s see how to find out the nth or say second maximum value in a column in excel.

We will see the formula Large (array,n) where n is the integer denoting the nth largest value in an array or section.

We have the data below and we are interested to find the second maximums revenue in the revenue column.

Capture




Enter the formula =LARGE(C2:C20,2)

Capture

If you want to know the 3rd, 4th ….largest value just the value as n in the formula and you will get the nth max value in the column.

Hope this helped.

Share The Knowledge

Random Posts

  • Put Value Within Quotes In Excel

    The post demonstrates how to put a value within a quotation mark in excel. Let’s see a scenario where we […]

    Share The Knowledge
  • Second Maximum Value In Excel

    A very common interview question that is asked in an excel interview is to find the second maximum value in a […]

    Share The Knowledge
  • Insert Watermark/Image In Excel

    The post demonstrates how to insert watermark in excel sheet.Watermark is used to prevent plagiarism and also it serves the […]

    Share The Knowledge
  • Combine Excel Column using Pandas In Python

    combine column in excel using pandas, excel combine columns using python pandas, combine column using pandas in excel

    Share The Knowledge

Leave a Reply