Advanced Filter

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I am trying to run a filter that excludes items from a
list. Since I am doing more than 2 items I am using the
advanced filter. In the "Criteria Range" I have the
heading of the column I want the filter to apply to and
the next cell (F2) has "<> "TEST" ". I specify a new
range for the filter data to be copied to and TEST keeps
showing up in the output. Any ideas?

Thank you!
 
In cell F2, enter: <>Test

If case is important (e.g. only TEST, not Test), then you can use a
formula in the criteria range.
 
Back
Top