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
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