C
Chris Guay
Could someone out there please tell me how to return
multiple MAX values, e.g. say 3.
multiple MAX values, e.g. say 3.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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)
=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)
C
Chris Guay
Thanks Bob, much appreciated.
It's -35 here today.
It's -35 here today.
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
=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)
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)