LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Louise
 
Posts: n/a
Default Advanced Filters

I have a worksheet containing various data, including staff names, their
start date and the department they work for.

I am trying to use an Advanced Filter which will give me a list on another
worksheet of those staff who started after a particular date but, for some
reason, I can't get it to work.

My 'criteria' looks like:-

Name Start Date
01/01/05


I have made sure that al the cells containing dates are formatted in the
same way but it still doesn't work.

I have created quite a few filters and they have all worked fine, apart from
when I try to use dates.

Any ideas what I'm doing wrong???

Thank you.

Louise
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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
advanced filters jiwolf Excel Worksheet Functions 4 October 18th 05 06:08 PM
Help: Multiple filters with mutually exclusive items six50joe Excel Discussion (Misc queries) 5 September 28th 05 02:41 PM
Req: How to create multiple mutually exclusive filters six50joe Excel Worksheet Functions 2 September 26th 05 11:08 PM
Advanced Filters Louise Excel Worksheet Functions 3 September 26th 05 11:57 AM
How to aviod reset of Pivot filters when reconnecting to database? Tonny Olesen Excel Discussion (Misc queries) 1 July 9th 05 01:26 AM


All times are GMT +1. The time now is 02:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"