Thread: Wildcards in Advanced filter criteria don't work with Excel 2003
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default Wildcards in Advanced filter criteria don't work with Excel 2003
Wildcards seem to work in Excel 2003. Can you give an example of the
criteria you're using, and the results you get in the different versions
of Excel?

Inconceivable wrote:
Technique: Filtering a list using Advanced Filter (filter-in-place). Using
wildcards used to work in earlier versions of Excel, but it doesn't seem to
work in Excel 2003.

I have 2 PCs, one with Excel 2002 at work and one with Excel 2003 at home.
The same Excel file will work in Excel 2002 and fail in Excel 2003.

It may be fixed in a service pack which I don't have.....


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote