View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default Autofilter: Does Not Contain

When using Contain/Begin with, don't use the wildcard.

--
Best Regards,

Luke M
"Jenna" wrote in message
...
I have a worksheet with several columns that are autofiltered. In one
column,
I am trying to custom filter utilizing Does Not Contain 0.11588*. The
0.11588* is due to the fact that there are three items that begin with
these
digits. I have tried Does Not Begin With as well. Neither work. Then, I
tried
to use Contain, to see if that worked. It doesn't. My goal is to filter
these
out so that I can get a quantity sum on the remaining parts. I also have a
column for shipped dates that is filtered to Blanks only.