| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| How can I use Excel to solve an equation? | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
