Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advanced filters | Excel Worksheet Functions | |||
Help: Multiple filters with mutually exclusive items | Excel Discussion (Misc queries) | |||
Req: How to create multiple mutually exclusive filters | Excel Worksheet Functions | |||
Advanced Filters | Excel Worksheet Functions | |||
How to aviod reset of Pivot filters when reconnecting to database? | Excel Discussion (Misc queries) |