Autofilter shows no results, but there should be because there are matches

R

RF tech

the column that I am trying to use autofilter on has nothing but
numbers in it. But when I do a custom filter for a number that begins
with '5' (for example), it shows no results. Even though there are
plenty of numbers that start with '5'. I do the same excercise on
another worksheet that is formatted the same, and it works fine. If I
go back to the non-working worksheet and retype the number in each
cell the autofilter will work. WHY OH WHY is this so?
 
T

tamarakay

That happened to me whenever I imported data from a particular database. On
import, somehow a little 1/2 space was put in front of each data entry. I had
to strip those 1/2 spaces out, then all my filters worked.
 
Top