Aladin,
Thanks for the response. I tried the function but could not get it to
work. I am going to try and attach a sample file (.pdf) for you to see
what I am attempting. Any additional help is greatly appreciated.
Thanks!
Aladin Akyurek Wrote:
Assuming that the durations are true numbers, e.g., 09 is really 9, not
text...
=MIN(IF(TEXT(DateProcessedRange,"mm-yyyy")=TEXT(F2,"mm-yyyy")),DurationRange))
which you need to confirm with control+shift+enter instead of just with
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 |
+-------------------------------------------------------------------+
--
Chad S
------------------------------------------------------------------------
Chad S's Profile:
http://www.excelforum.com/member.php...o&userid=15747
View this thread:
http://www.excelforum.com/showthread...hreadid=272660