Use the LARGE function:

=LARGE(A1:C3,3)

HTH
Jean-Guy

"Crawdaddy" wrote:

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,