I am trying to use advance filtering to filter down a list given 2 criteria.
it will be more than 2 in some cases, but for the simplicity of this post,
i'll say 2. the Description column... i want to filter it down to rrecords
that contain the text "fireplace" and do NOT contain the text "outdoor".
(tryinging to isolate indoor fireplaces only. the criteria i came up with is:
="<*outdoor*"
="=*fireplace*"
but when i filter, it doesn't seem, to be filtering down the list for all
the criteria... only the first one. Yes, i am selecting the criteria range
with the header and both criteria. i have had this work with both criteria
individually, but not together. TIA.