Max Function
 

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,

Max Function
 

=LARGE(A1:C3,3)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Crawdaddy" wrote in message
...
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,

Max Function
 

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,

Max Function
 

use large(rangename,3)


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=510023