Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Chad S
 
Posts: n/a
Default Need to find Min value based on date range entered


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

  #2   Report Post  
Aladin Akyurek
 
Posts: n/a
Default


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate interest and deduct late fees based on date pa. leon New Users to Excel 1 January 6th 05 03:09 PM
How do I change the value in cell based on a future date John W Excel Discussion (Misc queries) 2 December 21st 04 02:27 AM
Selecting data from a list based on entered values GrantM Excel Discussion (Misc queries) 1 December 20th 04 11:59 AM
Counting values within a Date Range Jana Excel Discussion (Misc queries) 7 December 9th 04 11:18 PM
Use MATCH to find position of max in 2D range? Peter B Excel Worksheet Functions 4 October 28th 04 05:23 PM


All times are GMT +1. The time now is 01:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"