Max function

Stan Altshuller · Dec 14, 2004

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

Dave R. · Dec 14, 2004

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

Frank Kabel · Dec 14, 2004

Hi
=LARGE(A1:A100,2)

How do I search for the second largest value in the array?	2	Apr 22, 2010
Looking up name with 2 criteria	5	Mar 7, 2010
Compressing multiple functions across an array into one cell	6	Sep 14, 2012
Function for 2nd and third low or Max	2	Sep 17, 2009
Treating multiple paragraphs as one	2	Apr 26, 2021
SUMPRODUCT to substiute array formula	7	Feb 26, 2010
WORD VBA Search and switch to advanced ...	1	Jul 21, 2021
How to use large function?	5	Feb 24, 2007

Ask a Question