![]() | ![]() | ![]() |
| |||||||
| Forums | Register | Groups | Awards | Arcade | Pets | T-Bucks / T-Store | Invite Your Friends | Blogs | Mark Forums Read |
| Microsoft Applications Discussions about Windows and other MS Products such as Office |
![]() |
| | LinkBack | Thread Tools |
| | #1 (permalink) |
| Civilians | Is it possible to select rows based on a date range (say from 01-01-2005 to 31-12-2005) from column B: A B C id date value 1 01-01-2005 1 2 06-01-2005 1 3 08-02-2005 1 4 16-02-2005 1 5 03-03-2005 1 6 01-01-2004 1 7 06-05-2006 1 8 05-05-2005 1 9 06-06-2005 1 10 09-0 1 sum 10 Morten |
|
| | #2 (permalink) |
| Civilians | Yes.............after clicking the AutoFilter arrow on your column of choice, choose "Custom" and in the pop-up select the "greater than" and "less than" options to give you your range of dates............ Vaya con Dios, Chuck, CABGx3 "hansiman" <hansi@hotmail.com> wrote in message news:ti3q119inco8uq2qilsuioe2a9h5d9s3ml@4ax.com... > Is it possible to select rows based on a date range (say from > 01-01-2005 to 31-12-2005) from column B: > > A B C > id date value > 1 01-01-2005 1 > 2 06-01-2005 1 > 3 08-02-2005 1 > 4 16-02-2005 1 > 5 03-03-2005 1 > 6 01-01-2004 1 > 7 06-05-2006 1 > 8 05-05-2005 1 > 9 06-06-2005 1 > 10 09-0 1 > sum 10 > > Morten > |
|
![]() |
| Bookmarks |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Formatting (How to format a range depending on another range) | Josh Rogers | Microsoft Applications | 2 | 10-06-2005 18:00 |
| Re: date range missing | John | Microsoft Applications | 1 | 08-25-2005 20:00 |
| Selecting only active range | oz_saar | Microsoft Applications | 2 | 08-11-2005 08:00 |
| Need help with selecting a Range.... | RompStar | Microsoft Applications | 2 | 07-17-2005 20:00 |
| How do i sort a range and place the results in another range without using Macros? | Douglas | Microsoft Applications | 1 | 01-28-2005 12:00 |
![]() | ![]() | ![]() |