The second minimum

M

Murat Kardesci

Hey,

Is there a speical function or a way which could give me the second minimum
number in a given set of numbers?

Such as, given the set of numbers,

5
6
2
7
3

Function should return 3 ?

Thanks alot
 
A

Alan Beban

Murat said:
Hey,

Is there a speical function or a way which could give me the second minimum
number in a given set of numbers?

Such as, given the set of numbers,

5
6
2
7
3

Function should return 3 ?

Thanks alot
Click to expand...
=SMALL({5,6,2,7,3},2)

Alan Beban
 
Top