Go Back   Trackpads Community > General Discussions > Computer and Technology > Microsoft Applications

Microsoft Applications Discussions about Windows and other MS Products such as Office

Reply
 
LinkBack Thread Tools
Old 02-23-2005, 20:00   #1 (permalink)
hansiman
Civilians

 
Default selecting date range / data range autofilter

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

 
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Trackpads Information
Click to Visit
Old 02-24-2005, 00:00   #2 (permalink)
CLR
Civilians

 
Default Re: selecting date range / data range autofilter

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
>



 
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
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
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


Community Information
Options
Quick Options
Trackpads Non-Commercial Ad
Copyright Information Click to Visit
Time
Server Time
All times are GMT -4. The time now is 11:17.
Copyright
Copyright Information
The header is based off of work by Vipixel.com and modified by this site. Trackpads and the Trackpads Logo are both Registered Trademarks of Jason Edwards and cannot be used without prior written permission.  The only exception is as a link back to this site. Trackpads is a private website run by a small legion of volunteers, 3 dogs, 12.5 cats and an army of small, super smart, bio-engineered mice with pointy hats and tutu's. Search Engine Friendly URLs by vBSEO 3.2.0 RC7
Archive Links
Archive Links
Page generated in 0.59996 seconds with 19 queries