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.
Enter the formula =LARGE(C2:C20,2)
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.