PDA

View Full Version : [SOLVED] filtering with * as one of the multiple criteria



selfteaching
10-31-2018, 03:06 PM
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
10-31-2018, 03:52 PM
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))


23111

Is that what you meant?

selfteaching
10-31-2018, 06:00 PM
Hi Paul,
Yes
That is exactly want i need
Thank you


mike