Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN DATE from Array
Need some help with a MIN formula - the MAX works fine. He's the
formula: {=MIN(($B$2:$B$8983=$N2)*($K$2:$K$8983))} {=MAX(($B$2:$B$8983=$N2)*($K$2:$K$8983))} I know why I get the answer I get, but don't know how to fix it. The formula causes ZEROS when the model doest match the one I'm interested in, hence the 00-Jan-00 below. How do I write a formula to give me the MIN (starting date) for the info in the table? A B D E F 175BR 06-Jan-08 MIN MAX 175BR 01-Mar-08 175BR 00-Jan-00 01-Mar-08 197SD 06-Jan-08 197SD 00-Jan-00 15-Feb-08 197SD 15-Jan-08 391SB 00-Jan-00 17-Feb-08 197SD 15-Feb-08 391SB 02-Jan-08 391SB 17-Feb-08 -Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN DATE from Array
=MIN(IF($B$2:$B$8983=$N2,$K$2:$K$8983))
ctrl+shift+enter, not just enter " wrote: Need some help with a MIN formula - the MAX works fine. He's the formula: {=MIN(($B$2:$B$8983=$N2)*($K$2:$K$8983))} {=MAX(($B$2:$B$8983=$N2)*($K$2:$K$8983))} I know why I get the answer I get, but don't know how to fix it. The formula causes ZEROS when the model doest match the one I'm interested in, hence the 00-Jan-00 below. How do I write a formula to give me the MIN (starting date) for the info in the table? A B D E F 175BR 06-Jan-08 MIN MAX 175BR 01-Mar-08 175BR 00-Jan-00 01-Mar-08 197SD 06-Jan-08 197SD 00-Jan-00 15-Feb-08 197SD 15-Jan-08 391SB 00-Jan-00 17-Feb-08 197SD 15-Feb-08 391SB 02-Jan-08 391SB 17-Feb-08 -Steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN DATE from Array
Perfect Thanks...
On May 12, 8:17*am, Teethless mama wrote: =MIN(IF($B$2:$B$8983=$N2,$K$2:$K$8983)) ctrl+shift+enter, not just enter " wrote: Need some help with a MIN formula - the MAX works fine. *He's the formula: {=MIN(($B$2:$B$8983=$N2)*($K$2:$K$8983))} {=MAX(($B$2:$B$8983=$N2)*($K$2:$K$8983))} I know why I get the answer I get, but don't know how to fix it. *The formula causes ZEROS when the model doest match the one I'm interested in, hence the 00-Jan-00 below. *How do I write a formula to give me the MIN (starting date) for the info in the table? * *A * * * * * * * *B * * * * * * * * * * * * * * D E * * * * * * *F 175BR * * *06-Jan-08 * * * * * * * * * * * * * *MIN * * * * * *MAX 175BR * * *01-Mar-08 * * * * * * * 175BR * 00-Jan-00 * * * 01-Mar-08 197SD * * *06-Jan-08 * * * * * * * 197SD * 00-Jan-00 * * * 15-Feb-08 197SD * * *15-Jan-08 * * * * * * * 391SB * 00-Jan-00 * * * 17-Feb-08 197SD * * *15-Feb-08 391SB * * *02-Jan-08 391SB * * *17-Feb-08 -Steve- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Lookup to Find Closest Date and Next Closest Date | Excel Worksheet Functions | |||
Conditional date array formula | Excel Discussion (Misc queries) | |||
Conditional Array Formula for date | Excel Discussion (Misc queries) | |||
date array shifting | Excel Discussion (Misc queries) | |||
Macro to sum array by date | Excel Worksheet Functions |