Max function

[Stan Altshuller]

How can one find the second largest (third, fourth) number in array
a1:a100?

 

[Dave R.]

Use LARGE, e.g. =LARGE(A1:A100,4)

 

[Frank Kabel]

Hi
=LARGE(A1:A100,2)