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.

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.

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.

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.

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.

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.