Thread: trying to do custom autofilter but its not recognising "*"as wild
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default 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 With QuoteReply With Quote