Max Function

[Crawdaddy]

I have the values as follows in a worksheet...

1 25 6
7 9 13
18 27 4

I need a formula to display the 3rd largest value.

Thanks,

 

[Bob Phillips]

=LARGE(A1:C3,3)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[pinmaster]

Use the LARGE function:

=LARGE(A1:C3,3)

HTH
Jean-Guy

 

[bob777]

use large(rangename,3)