Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Good day Group, Have a problem concering advanced filter and formats. In a column there is data representing dates. The data are put in the column by textboxes, the column is formated as text. Date 20060201 20060225 20050303 20040815 20060525 etc When trying to filter by the advanced filter there is nothing found by using criteria like: Date <=20050101 but is working when the criteria looks like: Date <=20050101* have checked the length of the textstring and there are no "hidden" letters or spaces. It also looks like <= operand is working fine but when using the = the data that is = to the criteria is ignored. Hopeful for some hints how to go on with this problem Brgds CG Rosén |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
advanced filter format problem | Excel Programming | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |