Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select rows in a date range
This code from Bob Phillips works brilliantly for two input dates that match
the dates in the range!! http://www.microsoft.com/office/comm...sloc=en-us&p=1 I am wondering how to make a change to allow Excel to find the next higher date in the range if there is not an exact match between the two input dates and the dates in the range. Thanks so much, Ryan-- -- RyGuy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select rows in a date range
Ah! I got it! Just changed those zeros to ones. From Excel's help:
If match_type is 1, MATCH finds the largest value that is less than or equal to lookup_value. Thanks to anyone who looked at this and thanks to you Bob for coming up with the code and posting it on this DG!! Ryan-- -- RyGuy "ryguy7272" wrote: This code from Bob Phillips works brilliantly for two input dates that match the dates in the range!! http://www.microsoft.com/office/comm...sloc=en-us&p=1 I am wondering how to make a change to allow Excel to find the next higher date in the range if there is not an exact match between the two input dates and the dates in the range. Thanks so much, Ryan-- -- RyGuy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
Select all rows in a date range | Excel Programming | |||
Select always same Rows range | Excel Discussion (Misc queries) | |||
Select a Range of (Variable) Rows | Excel Programming | |||
How to select rows containing certain date | Excel Programming |