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
|