Heelp...the "begin with" custom filter does not work

  • Thread starter Question_from_holland
  • Start date
Q

Question_from_holland

I have series of data which i want to manage. For this, i used the custom
autofilter. Everything of this filter works, except the "begin with" and "end
with" filter! I don't know why. Really, i have tried everything.... Could
anybody help me on this please!!!
 
J

JulieD

Hi

works fine for me, could you please type out a sample of your data and
explain what you have chosen in the "custom" box.

Cheers
JulieD
 
D

Debra Dalgleish

"Begins with" and "Ends with" work with text, but not with dates or
numbers. If that's the type of data you want to filter, you could add a
new column to your table.

For example, if numbers are in column C, create a column with the
formula: =LEFT(C2,1)
If you want to find dates with a specific month, create a column with a
formula like: =MONTH(C2)
 
Top