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

M

max power

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

Debra Dalgleish

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