filtering with * as one of the multiple criteria

[selfteaching]

Hi
I’m using filter> advance to find entries in a list of data.
I know I can use multiple criteria.
One of the rows is dates. mm/dd/yy
I’m wondering if I can somehow use a * (star) and the year 2018 to only return mm/dd/18 dates with the other criteria.
example
If I use the criteria misc, it returns all ..2015..2016..etc
I only want 2018
What I do now is use the filter and then delete the unwanted dates
It’s not hard because it’s all in order.
But I’m wondering if it can be done

I tried **/**/18 as one criteria and misc as the other but I get no results

mike

[Paul_Hossler]

Whenever I've used Advanced Filter, I set up the Criteria E1:G3 like this

(Dates >= 1/1/2018) AND (Dates <1/1/2019) AND ((Other=Dog) OR (Other=Cat))


Capture.JPG

Is that what you meant?

[selfteaching]

Hi Paul,
Yes
That is exactly want i need
Thank you


mike