=Max()

[DaddyH]

Hi guys, easy one i think!

if i have a set of numbers:

20
25
30
15
18
27
etc


=max(cell range) in this instance would return the value of 30


if i wanted it it return the second highest number in this instance 27 wwhat formula would i need?


Cheers

Daddy H

 

[VoG]

Try

=LARGE(range,2)

 

[Jonmo1]

Try LARGE

=LARGE(cell range, 2)

Hope that helps

 

[DaddyH]

Brill! cheers!!