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.

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
news:F72777A3-3E35-42E5-A446-(E-Mail Removed)...
>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.

=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
news:F72777A3-3E35-42E5-A446-(E-Mail Removed)...
>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.

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 news:F72777A3-3E35-42E5-A446-(E-Mail Removed)...
|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.

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> =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
> news:F72777A3-3E35-42E5-A446-(E-Mail Removed)...
>>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.
>
>

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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > =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
> > news:F72777A3-3E35-42E5-A446-(E-Mail Removed)...
> >>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.
> >
> >
>
>
>