×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Advanced Filter Function Exclude

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?   

RE: Advanced Filter Function Exclude

not able to open attached file . . .  please try attaching file again using "STEP 3" in posting procedure.

Thanks!
-pmover

RE: Advanced Filter Function Exclude

As pmover said, your file is inaccessible.

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

Have you tried ="<> - "
 

RE: Advanced Filter Function Exclude

It seems like the ="<> - " gets rid of all, but one of the ones with just a dash.  The one that it misses doesn't have the space after the dash.

RE: Advanced Filter Function Exclude

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources