custom autofilter does not work
If all the numbers are the say between 10,000 and 99,000, you could use a custom
filter of greater than And Less than.
If you want to show numbers that start with 12, like 12345 and 121, then you
could use another column and fill it with formulas:
=a2&""
The &"" will make excel treat the entry as text and you can do what you want.
Max wrote:
Hi there,
I have Microsoft Excel 2003 version (dont know if makes a difference but i
mention it). I have a list with numbers and I have Autofilter activated but
when I selected Custom and then the option "begins with" or "contains" it
does not bring any result. Even when I selected the hole number that I want
to filter (although I want all the numbers that start with some common digits
with this one).
I dont know if this version has any problem with that thing. I have used the
same feature in the past with previous versions and it worked just fine.
If anybody has something in mind I would be very grateful
--
Dave Peterson
|