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"
Excel Advanced Filter string equal to AND string Not equal to
332 views Asked by user1955215 At
1
Filter drop menu on cell-> Text filter -> equals "cdef"