| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Criteria governing "LARGE" function
I have a column of numbers, and would like to find the "largest number".
However I need it to be less than 130. something like =LARGE(C1:C20,(1<130)), I've tried several different things, but nothing really works. Thanks in advance! Mike. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Criteria governing "LARGE" function
Try this
=MAX(IF(C1:C20<130,C1:C20)) enter it with ctrl + shift & enter -- Regards, Peo Sjoblom "M.A.Tyler" <Great Lakes State wrote in message ... I have a column of numbers, and would like to find the "largest number". However I need it to be less than 130. something like =LARGE(C1:C20,(1<130)), I've tried several different things, but nothing really works. Thanks in advance! Mike. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Criteria governing "LARGE" function
=MAX(IF(C1:C20<130))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "M.A.Tyler" <Great Lakes State wrote in message ... I have a column of numbers, and would like to find the "largest number". However I need it to be less than 130. something like =LARGE(C1:C20,(1<130)), I've tried several different things, but nothing really works. Thanks in advance! Mike. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Criteria governing "LARGE" function
Hi Mike,
=LARGE(C1:C120,COUNTIF(C1:C120,"130")+1) -- Kind regards, Niek Otten Microsoft MVP - Excel "M.A.Tyler" <Great Lakes State wrote in message ... |I have a column of numbers, and would like to find the "largest number". | However I need it to be less than 130. something like =LARGE(C1:C20,(1<130)), | I've tried several different things, but nothing really works. | | Thanks in advance! | | Mike. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Criteria governing "LARGE" function
type
=MAX(IF(C1:C20<130,C1:C20)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bob Phillips" wrote in message ... =MAX(IF(C1:C20<130)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "M.A.Tyler" <Great Lakes State wrote in message ... I have a column of numbers, and would like to find the "largest number". However I need it to be less than 130. something like =LARGE(C1:C20,(1<130)), I've tried several different things, but nothing really works. Thanks in advance! Mike. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Criteria governing "LARGE" function
Works Great
Thanks to all! "Bob Phillips" wrote: type =MAX(IF(C1:C20<130,C1:C20)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bob Phillips" wrote in message ... =MAX(IF(C1:C20<130)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "M.A.Tyler" <Great Lakes State wrote in message ... I have a column of numbers, and would like to find the "largest number". However I need it to be less than 130. something like =LARGE(C1:C20,(1<130)), I've tried several different things, but nothing really works. Thanks in advance! Mike. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Function to find 'n'th largest alphanumeric field (like "Large") | Excel Worksheet Functions | |||
| Looking up the results from the function "LARGE" | Excel Worksheet Functions | |||
| Utility to "clean up" or "defrag" large Excel file | Excel Discussion (Misc queries) | |||
Linear Mode
