+ Reply to Thread
Results 1 to 4 of 4

Advanced filter- Not equal to

  1. #1
    Forum Contributor
    Join Date
    07-27-2009
    Location
    montreal, canada
    MS-Off Ver
    Excel 2003
    Posts
    230

    Advanced filter- Not equal to

    Hi,
    I'm trying to add multiple criterias to my advanced filter, and as soon as I add another "ship to" criteria, the filter does nothing.

    See attached file in second post ( i can't edit my first post's attahcment)

    Here's my criteria matrix:

    Interco ShipTo
    Interco Sales <>1925*
    Interco Sales <>2392*
    External Sales


    So that second interco sales criteria ruins the filter...

    Anyone can help?
    Attached Files Attached Files
    Last edited by Sibrulotte; 12-30-2010 at 03:28 PM.

  2. #2
    Forum Contributor
    Join Date
    07-27-2009
    Location
    montreal, canada
    MS-Off Ver
    Excel 2003
    Posts
    230

    Re: Advanced filter- Not equal to

    to add attachment to first post.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2007 Enterprise
    Posts
    728

    Re: Advanced filter- Not equal to

    Use this criteria

    ="<>192501 - AMERICAN YEAST - DERRY"

    see attached sheet

    Regards
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    07-27-2009
    Location
    montreal, canada
    MS-Off Ver
    Excel 2003
    Posts
    230

    Re: Advanced filter- Not equal to

    Right, thanks, didn't ave that sideways.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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