I would like to create an advanced filter criterion that works in reverse; in
other words, it doesn't select rows BECAUSE they contain a specified value,
it selects all rows that do NOT contain a specified value. For example, if I
have a column that contains any of the 26 individual letters of the alphabet
as a code (meaning the value for that column in each individual row would
either be the single letter "A" or "B" or "C", etc.), I want the filter to
return all rows that have a value OTHER THAN "X" (so that the result would be
rows that had any value of A-W or Y or Z). How can I do this?
Thanks,
Eric
Bookmarks