| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
trying to do custom autofilter but its not recognising "*"as wild
i am trying to use the auto filter and have selected custom under custom i
have selected "does not equal to" and the typed "6500*" but it is still showing all rows that contain data like 650011, 650009, 650006. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
trying to do custom autofilter but its not recognising "*"aswild
You can't use wildcards to AutoFilter for a number within a number.
You could add a column in which you calculate the left 4 characters of the number: =LEFT(G2,4) Then, AutoFilter that column for 6500. max power wrote: i am trying to use the auto filter and have selected custom under custom i have selected "does not equal to" and the typed "6500*" but it is still showing all rows that contain data like 650011, 650009, 650006. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom AutoFilter | Excel Worksheet Functions | |||
| Can I use more than two conditions in custom autofilter? | Excel Worksheet Functions | |||
| Custom autofilter Bug In excel 2002 | Excel Discussion (Misc queries) | |||
| custom autofilter does not work | Excel Discussion (Misc queries) | |||
| Custom Autofilter List | Excel Discussion (Misc queries) | |||
Linear Mode
