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

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.

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 helps
    Filiss
  • jackomdj
    jackomdj Posts: 3,073 Forumite
    Part of the Furniture 1,000 Posts
    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!
  • hotkee
    hotkee Posts: 505 Forumite
    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.
  • 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

    Rumpelstiltskin
    Filiss
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

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

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.