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!

Recent content by Schlunggi

  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?
See more

Part and Inventory Search

Back
Top Bottom