View Single Post
  #1   Report Post  
Robert
 
Posts: n/a
Default Can Excel advanced filter be used in "and NOT" mode

Can Excel 2000 advanced filter be used to select rows in a list that do not
match the comparison criteria? Or, otherwise, once advanced filter is
employed and a list a matching rows is identified, can the hidden rows be
selected and copied?