The second minimum

  • Thread starter Thread starter Murat Kardesci
  • Start date Start date
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
 
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
 
Back
Top