trying to do custom autofilter but its not recognising "*"as wild
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. |
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 |
All times are GMT +1. The time now is 11:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com