We'd like to remind Forumites to please avoid political debate on the Forum. This is to keep it a safe and useful space for MoneySaving discussions. Threads that are - or become - political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
We're aware that dates on the Forum are not currently showing correctly. Please bear with us while we get this fixed, and see Site feedback for updates.
excel date filter

hotkee
Posts: 505 Forumite
in Techie Stuff
My bro does excel work and wants to know how to do the following
Given data in columns
Date, City, Town, Name
he wants to filter the Date field to be in a range say 1-jan-9 to 10-jan-9.
He is using excel 2000 (yep thats what they have at his workplace till they upgrade).
Now there is advanced filter thing but I need a real simple example that works - anyone got an excel file which demonstrates this working. I know there are examples on the net but this is really non programming solution I want for him.
Its something that can be done easily in excel with using any programming.
Given data in columns
Date, City, Town, Name
he wants to filter the Date field to be in a range say 1-jan-9 to 10-jan-9.
He is using excel 2000 (yep thats what they have at his workplace till they upgrade).
Now there is advanced filter thing but I need a real simple example that works - anyone got an excel file which demonstrates this working. I know there are examples on the net but this is really non programming solution I want for him.
Its something that can be done easily in excel with using any programming.
0
Comments
-
Highlight the title row
Go to data - filter - auto filter
click on the down arrow in the date column and select custom.
This will allow you to put in a date range.
Hope this helpsFiliss0 -
Can't show you as my home version of excel is a lot more rexcent. But:
Highlight the title rows & click on data, filter, autofilter.
Click on the dropdown arrow on the date cell.
click on the drop down arrow (where it says equal to) & change to greater than or equal to, on the drop down next to it type your lower date or select the date fom the list.
leave the & button selected.
click the bottom drop down arrow & change to less then or equal to, on the drop down next to it type your upper date or select the date fom the list.
The thing to make sure is that your column is in a date format so it looks up properly (eg in excel type '05/06/09 this will show as 05/06/09 but is a text string....if you format it as a date it is actually stored as a number within excel's memory - 39969 is the number representing 05/06/09!)
HTH
Nicky
see I should not do other stuff at the same time you got another answer before I posted!0 -
Thats what I would do - but its my bro's workplace has excel 2000.
I have ms office 2007 at home and openoffice in linux.
According to what my bro - excel 2000 doesnt allow those simple things to be done.
I am techy enough myself but can't give him a definite answer without excel 2000 in front of me hard to tell what was possible with that version.
Thanks for the replies.0 -
Can definately be done in excel 2000.
Doen't have the Ribbon like 2007 but if he clicks on the data menu he will be able to do it. There is a youtube tutorial
http://www.youtube.com/watch?v=234GasE_W9k
RumpelstiltskinFiliss0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 348.4K Banking & Borrowing
- 252.1K Reduce Debt & Boost Income
- 452.4K Spending & Discounts
- 241K Work, Benefits & Business
- 617.3K Mortgages, Homes & Bills
- 175.7K Life & Family
- 254.1K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 15.1K Coronavirus Support Boards