Results 1 to 4 of 4

Advanced filter not equal (<>) results

Threaded View

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

    Advanced filter not equal (<>) results

    I´m 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

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. [SOLVED] Need Advanced Filter with NOT equal string and OR criteria
    By MK in forum Excel General
    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