| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Maximum value for Specific Month(s)
Hi All,
I have a dynamic named range called "Data" that spans 10 columns and many rows. I would like to have the maximum value for the month of Jan (January - month will vary) returned for column number 6. The month is a full date eg: 01/01/2006 using a custom short format "mmm" = Jan. Column 2 = Full Date formatted as month "mmm" Column 6 = Numeric Values - max value to be returned Column 7 = Numeric Values - max value to be returned Column 8 = Numeric Values - max value to be returned Cheers, Sam -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| annualized return calculation for the purpose of portfolio performance evaluation | Excel Worksheet Functions | |||
| Add # of months and get result last day of # months. | Excel Discussion (Misc queries) | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
| Return a date 6 months from a date in another cell | Excel Worksheet Functions | |||
Threaded Mode
