Advanced Filter Function Exclude
Advanced Filter Function Exclude
(OP)
I am trying to exclude lines which only contain " - " Space,dash (Char 32),space. I have tried just about any combination with <> (not equal) but excel is ignoring it.
If I use ="= - " it will filter only these lines, but I can not exclude them. Has anybody a solution?
If I use ="= - " it will filter only these lines, but I can not exclude them. Has anybody a solution?





RE: Advanced Filter Function Exclude
Thanks!
-pmover
RE: Advanced Filter Function Exclude
If your doing this with a macro, I'd do something like this:
1. Have a cell in your spreadsheet (e.g., A1)with " - "
2. In your macro make a variable refer to that cell (e.g., A$=Range("A1")
3. Have a condition when your data in a cell = A$
RE: Advanced Filter Function Exclude
The problem is the <> not equal, the = equal works.
Thanks for the replies.
RE: Advanced Filter Function Exclude
RE: Advanced Filter Function Exclude
RE: Advanced Filter Function Exclude
RE: Advanced Filter Function Exclude
Thanks for the tip.