I’m using CONTAINS to filter a REF column. The REF is a Job. The column it checks is the Days. This works except I have Day 1 and Day 10 that can be in the column. So when it checks for Day 1 it allows Day 10.
Is there any fix for this? I could put a comma after the number, Day 1, but if Day 1 is the only day that’ll be missed then.
Hope that makes sense. I know I haven’t put much info. Thanks