Excel Advanced Filter string equal to AND string Not equal to

311 views Asked by At

A column contains strings "abcdef" and "cdef". A row contains either abcdef or cdef but not both. What would the Advance filter criteria be for filtering out rows with "cdef" but not "abcdef"

1

There are 1 answers

0
Hans Chen On

Filter drop menu on cell-> Text filter -> equals "cdef"