Retreiving top 3 MAX values

C

Chris Guay

Could someone out there please tell me how to return
multiple MAX values, e.g. say 3.
 
B

Bob Phillips

Chris,

=LARGE(A1:A100,1)

replace the 1 by 2 for 2nd largest, 3 for 3rd.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
K

Ken Wright

Or select 3 contiguous cells horizontally and type

=LARGE(A1:A100,{1,2,3})

and array enter using CTRL+SHIFT+ENTER


Or select 3 contiguous cells vertically and type

=LARGE(A1:A100,{1;2;3})

and array enter using CTRL+SHIFT+ENTER
 
B

Bob Phillips

Chris,

Where is here? It's a pleasant, sunny 10 here.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top