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

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

Guest

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!!!
 
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
 
"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)
 
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: Does Not Contain 2
Auto Filter Does Not Work 3
Cannot use autofill after filtering 4
cannot use autofill after filtering 1
Auto Filter problems 2
Multiple criteria for filters 4
custom autofilter does not work 2
Excel auto-filter does not filter certain columns 5

Back
Top