Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter - filter rows <
Why does using the < operator work for filter criteria one column but not in
another? It does not filter out the rows in my "Store Number" column. Example: The following does not work... Store <4 This works... Location <Outdoor |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter - filter rows <
Hi
Maybe your store numbers are really text Try Store <"4" -- Regards Roger Govier "jaws4518" wrote in message ... Why does using the < operator work for filter criteria one column but not in another? It does not filter out the rows in my "Store Number" column. Example: The following does not work... Store <4 This works... Location <Outdoor |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter - filter rows <
I have tried text and number formats. If my value is formatted as a number
then <4 should return all row except for those with 4. Here is what I do know... I added a character to my number #4 and it filters fine. The not equal operator is not filtering a number regarless of the format. It does seem to work with the other operators. ,<,= "Roger Govier" wrote: Hi Maybe your store numbers are really text Try Store <"4" -- Regards Roger Govier "jaws4518" wrote in message ... Why does using the < operator work for filter criteria one column but not in another? It does not filter out the rows in my "Store Number" column. Example: The following does not work... Store <4 This works... Location <Outdoor |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter - filter rows <
Hi
There is no inherent reason why <4 should not work. It works fine on all applications where I use Advanced Filter. I would still suspect the data in the Store column. In a separate column on that sheet, enter =LEN(A2) and copy down, having substituted A2 with the cell number of your first store value. Does the result come to 1 for stores with a supposed value of 4? If not there may be leading or trailing spaces (Char(32), or the non-breaking space character (char(160). If you find the length is greater than expected, try entering in another column =SUBSTITUTE(SUBSTITUTE(A2,Char(160),"")," ","") and copy down. Copy this new data and Paste SpecialValues back over the data in your Store column and see if the advanced filter works then. -- Regards Roger Govier "jaws4518" wrote in message ... I have tried text and number formats. If my value is formatted as a number then <4 should return all row except for those with 4. Here is what I do know... I added a character to my number #4 and it filters fine. The not equal operator is not filtering a number regarless of the format. It does seem to work with the other operators. ,<,= "Roger Govier" wrote: Hi Maybe your store numbers are really text Try Store <"4" -- Regards Roger Govier "jaws4518" wrote in message ... Why does using the < operator work for filter criteria one column but not in another? It does not filter out the rows in my "Store Number" column. Example: The following does not work... Store <4 This works... Location <Outdoor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter not working | Excel Worksheet Functions | |||
Advanced Filter | Excel Discussion (Misc queries) | |||
Problem using Advanced filter | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) |