Thread: Advanced Filter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jean Jean is offline
external usenet poster
 
Posts: 78
Default Advanced Filter

I have to use an Advanced Filter and not the AutoFilter because of the size
of my database. What do I type in the criteria range if I want the result to
show all names that END in the letter "n"? I tried "*n" but my result was
all names that contained the letter "n". (I didn't use quotation marks in my
criteria.) Thanks!