View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Keith John Keith is offline
external usenet poster
 
Posts: 172
Default questions on advanced filter

On Tue, 18 May 2010 11:09:19 +0800, "ozgrid.com"
wrote:

You shouldn't need wildcard Characters as one has to force an exact match
with criteria like ="<term1"


Dave,

I removed the wildcards and the results were clearly not correct.

I would need to try this on a much smaller dataset to get a handle on
what the filter is doing.

Thanks for the suggestion.



John Keith