Hi All,
I am currently using an advance filter to show only records where data from my criteria range is present, however what I want to know is if I can do the opposite. So in essence I want to keep the same data in my criteria range, but only show records which don't meet this criteria.
Hopefully this makes sense.....
Thanks in advance
I am currently using an advance filter to show only records where data from my criteria range is present, however what I want to know is if I can do the opposite. So in essence I want to keep the same data in my criteria range, but only show records which don't meet this criteria.
Hopefully this makes sense.....
Thanks in advance