Autofilter: Does Not Contain

J

Jenna

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.
 
D

Dave Peterson

Contains/does not contain doesn't work very well with numbers.

I create another field and force it to be text:

=a2&""
or
=text(a2,"0.000000000")

Or something like this.

Then I can filter on this text field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top