| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced filter
I have trouble using advanced filter with 4 criteria: 1. Year of priority 2. 1 3. ="" 4. yr However, after filtering, rows that contain "5~20" do not go away. Any idea? How do I put in another criteria to do something such as "< 5~20"? Thank you -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=486101 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) | |||
| Can Excel advanced filter be used in "and NOT" mode | Excel Worksheet Functions | |||
| Advanced Filter using Date represented as text | Excel Worksheet Functions | |||
| Advanced Filter: No Filter | Excel Discussion (Misc queries) | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Linear Mode
