ExcelBanter - Max function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Max function (https://www.excelbanter.com/excel-worksheet-functions/7913-max-function.html)

Stan Altshuller

Max function

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

Dave R.

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

"Stan Altshuller" wrote in message
...
How can one find the second largest (third, fourth) number in array
a1:a100?

Frank Kabel

Hi
=LARGE(A1:A100,2)

--
Regards
Frank Kabel
Frankfurt, Germany

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

All times are GMT +1. The time now is 03:06 PM.