I have a quick question regarding an advanced filter on excel.
I have managed to set a filter which picks out the words in a column which I want using an advanced filter by typing the words into different rows in the criteria range. This works fine, but how do I change it to EXCLUDE these words?
Doesn't seem to work. The above was an example only, it's too much to go into what is actually on the sheet I'm doing but basically I have the advanced filter set up how you showed me quite some time ago.
That works really well.
I can use the advanced filter to search for several names at once by typing them in the same criteria range column but on seperate rows and adjusting the criteria range accordingly. There is no limit to how many names I can search for this way, but I can only only seem to search for names which I want to KEEP IN the filter not names I want to EXTRACT FROM the filter.
That's where my query lies.
If I have a list of surnames in column B, what do I type in the criteria range cells (say cells B2, B3, B4 & B5) to EXCLUDE "Smith", "Jones", "Brown" and "McDonald"?
By typing the words in on their own, I can remove the other names but I want to do the opposite without having to typ all the other words in the list in.
Am I making sense? Or is this dull, confusing and frankly less interesting than an in-flight magazine produced by Air Belgium??? ;o)