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

After some further thinking I've solved the problem.

I orginally had the criteria in a column (as below)

<*term1*
<*term2* and so on

but since each criteria was a "NOT" function the criteria needed to be
configured as a "OR", thus in a row (with each column containing the
header) like this:

column 1 column 2 column 3
col 1 header col 2 header column 3 header
<*term1* <*term2* <*term2* and so on



John Keith