Minimum but One??

[twogoodtwo]

Can anyone tell me how I can look up the "minimum but one" in a range of
cells??

There must be a way

Thanks in advance

 

[Niek Otten]

Use the SMALL() function

 

[Guest]

If you want the minimum use
=SMALL(A1:A100,1)
if you want the 2nd smallest value then use
=SMALL(A1:A100,2)

 

[twogoodtwo]

Thanks so much!