Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Schlunggi

    Advanced Filter Function Exclude

    Great, this is the solution. Yes, the one which is not filtered needs a space after the dash as all others do. Thanks for the tip.
  2. Schlunggi

    Advanced Filter Function Exclude

    I try a new upload and also will try the macro as suggested. The problem is the <> not equal, the = equal works. Thanks for the replies.http://files.engineering.com/getfile.aspx?folder=60cad752-38ed-4efe-a5f4-865cb630022a&file=FilterSample.xls
  3. Schlunggi

    Advanced Filter Function Exclude

    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?

Part and Inventory Search

Back
Top Bottom