Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2007

Tip: Looking for answers? Try searching our database.

Autofilter Wildcards Not Working on Number Column

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
soke2001 - 15 Sep 2007 03:10 GMT
Hello everyone...n00b question.

I'm using Excel 2003 to split up a daily spreadsheet between me and 2
of my peers. We split the orders based on the last 2 characters of the
order. The orders are all 7 digits and all numerical. Exp... 3215453.
For example... my number range is 00-33.

Every morning I have to scroll through the spreadsheet and manually
select my orders to obtain my daily workload, which can take up to 40
minutes. I tried using auto-filter with wildcards * & ?, but they
don't work. I'm typing my custom filter values as follows ?????33 and
*33, but they don't work. Are they supposed to work on numbers?

There has to be an easier way... please assist.

Thanks in advance!!

Javier Cortes
Peo Sjoblom - 15 Sep 2007 05:30 GMT
Do you have to post in all newsgroups? Multiposting is considered really bad
in these groups (in all newsgroups).

http://www.cpearson.com/excel/newposte.htm

Signature

Regards,

Peo Sjoblom

> Hello everyone...n00b question.
>
[quoted text clipped - 14 lines]
>
> Javier Cortes

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.