| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Linear Mode
