Chad S Wrote:
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!
=MIN(IF(TEXT(C5:C12,"mm-yyyy")=TEXT(D3,"mm-yyyy"),D5:D12))
which you need to confirm with control+shift+enter instead of just with
enter. Maybe you overlooked this confirmation bit.
This returns 7 for the data in your pdf file.
--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile:
http://www.excelforum.com/member.php...fo&userid=4165
View this thread:
http://www.excelforum.com/showthread...hreadid=272660