Need to find Min value based on date range entered

[Chad S]

Aladin,

Thanks for the response. I tried the function but could not get it t
work. I am going to try and attach a sample file (.pdf) for you to se
what I am attempting. Any additional help is greatly appreciated.

Thanks!

Assuming that the durations are true numbers, e.g., 09 is really 9, no
text...

=MIN(IF(TEXT(DateProcessedRange,"mm-yyyy")=TEXT(F2,"mm-yyyy")),DurationRange))

which you need to confirm with control+shift+enter instead of just wit
enter.

F2 supposed to house a true date criterion in the form of e.g.
1-Feb-04

+-------------------------------------------------------------------
|Filename: Example.pdf
|Download: http://www.excelforum.com/attachment.php?postid=2736
+-------------------------------------------------------------------

 

[Aladin Akyurek]

Aladin,

Thanks for the response. I tried the function but could not get it t
work. I am going to try and attach a sample file (.pdf) for you to se
what I am attempting. Any additional help is greatly appreciated.

Thanks!

=MIN(IF(TEXT(C5:C12,"mm-yyyy")=TEXT(D3,"mm-yyyy"),D512))

which you need to confirm with control+shift+enter instead of just wit
enter. Maybe you overlooked this confirmation bit.

This returns 7 for the data in your pdf file