Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter Problem
Hi
I am not sure if Advanced Filter is my answer but I have the following problem which I am trying to resolve. I have a worksheet that lists equipment we have hired to clients. It is laid out as: Job No | Start Date | End Date | No of days (a formula calculates this) | Gear1 (no hired) | Gear 2 etc. We have 19 pieces of gear that could potentially be hired. I would like to extract for a date range what has been hired e.g. from 20/3/09 - 19/4/09. In my test data I know I have more than one entry that should show up but only the first entry shows. My criteria is: Start Date Start Date End Date End Date =20/3/09 <=19/4/09 =20/3/09 <=19/4/09 Can anyone help as to what I am doing wrong? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel advanced filter problem | Excel Discussion (Misc queries) | |||
Problem with Advanced Filter Criteria | Excel Discussion (Misc queries) | |||
Advanced Filter problem | Excel Discussion (Misc queries) | |||
Problem using Advanced filter | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |