Second Minimum Value In Excel

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

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

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

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


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


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

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply