|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
07-10-2008, 05:37 PM
|
|||
|
|||
|
multiple criteria data filter
Column A contains names
Column B contains date joined Column C contains date left The search criteria area is in b1:c2 The data starts in a5 (headings) Quirks: not all joining dates are known. Most are empty. My filter question in English is the following: "I want to see every one who joined before 30/04/2008 and had not left before 30/04/2008. The problem is in the "had not". It is easy to do a filter for the date joined e.g. =or(b6="",b6<=30/04/2008) How do I get the "left" filter to work? I want to see all of the emtpys therefore c6="" and those that left after 30/04/2008 but not those that left before. PLEASE HELP!!! Txs, il ballerino carino 
|
|
#2
07-10-2008, 05:49 PM
|
||||
|
||||
|
Hi,
Does this help?
__________________
oldchippy -------------   Click here >>> Top Excel links for beginners to Experts Forum Rules >>>Please don't forget to read these
|
 |
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
