software

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,

=LARGE(A1:C3,3)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Crawdaddyquot; gt; wrote in message
...
gt; I have the values as follows in a worksheet...
gt;
gt; 1 25 6
gt; 7 9 13
gt; 18 27 4
gt;
gt; I need a formula to display the 3rd largest value.
gt;
gt; Thanks,
Use the LARGE function:

=LARGE(A1:C3,3)

HTH
Jean-Guy

quot;Crawdaddyquot; wrote:

gt; I have the values as follows in a worksheet...
gt;
gt; 1 25 6
gt; 7 9 13
gt; 18 27 4
gt;
gt; I need a formula to display the 3rd largest value.
gt;
gt; Thanks,


use large(rangename,3)--
bob777
------------------------------------------------------------------------
bob777's Profile: www.excelforum.com/member.php...oamp;userid=28504
View this thread: www.excelforum.com/showthread...hreadid=510023