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

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

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 -