MIN DATE from Array

[steven.britton]

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

 

[Teethless mama]

=MIN(IF($B$2:$B$8983=$N2,$K$2:$K$8983))

ctrl+shift+enter, not just enter

 

[steven.britton]

Perfect Thanks...

=MIN(IF($B$2:$B$8983=$N2,$K$2:$K$8983))

ctrl+shift+enter, not just enter







- Show quoted text -