+ Reply to Thread
Results 1 to 4 of 4

Advanced filter not equal (<>) results

  1. #1
    Registered User
    Join Date
    01-04-2015
    Location
    dk
    MS-Off Ver
    2010
    Posts
    8

    Advanced filter not equal (<>) results

    Im trying to filter a list to exclude certain elements, but show everything else. Since I have 4 criterias, i guess advanced filter is the way to go -when i get it working, it will be recorded as a macro.
    Question is; why does it only work with one <> condition? If I use the normal =somevalue, =somevalue2 etc, it filters from criteria range as it should.
    The names in the list can vary, and so can the number of items on the list (comes from a text file), but the ones i want to exclude is always present, and unfortunately not always in the same row
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,007

    Re: Advanced filter not equal (<>) results

    Try this.

    1. Give your exclusion list a named range...I called it Exclude...(not essential, just keeps it tidy, and you just adjust 1 range, and not a bunch of formulas)
    2, Use a helper column (I used B) and put this in B2, bopied down...
    =MATCH(A2,exclude,0)
    Apply (regular) filters, and filter on the error in column B, and you should be left with what you want.

    This can then be copied - as is - to where you want it to be
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-04-2015
    Location
    dk
    MS-Off Ver
    2010
    Posts
    8

    Re: Advanced filter not equal (<>) results

    I see where this is heading -It almost works, but i still have empty cells which gives the #n/a error -
    excuse me for being thick-headed, but I suppose im gonna filter the regular way on that error, right? Then I still get the empty cells.

  4. #4
    Registered User
    Join Date
    01-04-2015
    Location
    dk
    MS-Off Ver
    2010
    Posts
    8

    Re: Advanced filter not equal (<>) results

    I found this formula to be working
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Based on suggestions I got in this thread -Thanks!

    (Techically, it didnt answer my question, but it solved my problem!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Advanced Filter results don't match auto filter
    By WaterWings in forum Excel General
    Replies: 1
    Last Post: 09-13-2012, 05:37 PM
  2. Advanced filter- Not equal to
    By Sibrulotte in forum Excel General
    Replies: 3
    Last Post: 12-30-2010, 03:27 PM
  3. Results of List of Data with Advanced Filter
    By vtphilk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2008, 06:21 PM
  4. Replies: 5
    Last Post: 12-07-2005, 10:35 AM
  5. refresh advanced filter results
    By eagle in forum Excel General
    Replies: 2
    Last Post: 11-18-2005, 05:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1