Hello everyone, I am a newbie in this forum. Hoping to get help from all the experienced users here .
I am facing a problem with AdvancedFilter method in my code. There's no error, just not working the way I expected. My data has a column 'Direction' which stores East, West, North,.... When I give the criteria as Direction - "North", it returns all rows with direction, "North East" and "North West" in addition to "North". Same happens with South. How can I get just the rows with North? Thanks.