trying to do custom autofilter but its not recognising "*"as wild

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

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

Similar Threads

autofilter - custom... 2
Autofilter: Does Not Contain 2
Custom Autofilter 3
Excel Macro to use cells as a autofilter 0
autofilter function 5
autofilter problem 7
Autofilter, 1
MS Excel 2003 - Autofilter for protected cells 1

Back
Top