max function with condition
 

I have a range of data. In column A is Dates, in column B is amounts. I want
to find the maximum amount in each day in another column for calculating
interest. Can anyone provide me a function for the same.

Thanks in advance

max function with condition
 

=MAX(IF(B2:B200=--"2006-07-10",B2_B200))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"shaji" wrote in message
...
I have a range of data. In column A is Dates, in column B is amounts. I
want
to find the maximum amount in each day in another column for calculating
interest. Can anyone provide me a function for the same.

Thanks in advance

max function with condition
 

Ooops: I think you meant
=MAX(IF(B2:B200=--"2006-07-10",C2:C200))
(fastest typist east of Colorado)

Cheers,
--
AP


"Bob Phillips" a écrit dans le message de news:
...
=MAX(IF(B2:B200=--"2006-07-10",B2_B200))

which is an array formula, it should be committed with Ctrl-Shift-Enter,
not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"shaji" wrote in message
...
I have a range of data. In column A is Dates, in column B is amounts. I
want
to find the maximum amount in each day in another column for calculating
interest. Can anyone provide me a function for the same.

Thanks in advance

max function with condition
 

Thanks Ardus. I did mean colon

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ardus Petus" wrote in message
...
Ooops: I think you meant
=MAX(IF(B2:B200=--"2006-07-10",C2:C200))
(fastest typist east of Colorado)

Cheers,
--
AP


"Bob Phillips" a écrit dans le message de news:
...
=MAX(IF(B2:B200=--"2006-07-10",B2_B200))

which is an array formula, it should be committed with Ctrl-Shift-Enter,
not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"shaji" wrote in message
...
I have a range of data. In column A is Dates, in column B is amounts. I
want
to find the maximum amount in each day in another column for
calculating
interest. Can anyone provide me a function for the same.

Thanks in advance