Results 1 to 2 of 2

Multiple Criteria Filter

Threaded View

  1. #1
    Registered User
    Join Date
    06-08-2009
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    2

    Multiple Criteria Filter

    Hi,

    in the attached excel file I would like to filter all those accounts which have invoices in the category " 2 to 7". However, in these accounts I also want to include invoices, which belong to these accounts, but are in the category "0 to 1".


    Those accounts which have invoices which are ONLY in the category "0 to 1" should be filtered OUT.

    To sum it up, an account A which invoices in the category 0,1 ,...,7 should be there in the report. An account with invoices in the category 2, 3,...,7 should be there. An account which has invoices only in the category "0 and 1" should be filtered out.

    Any ideas how this might be possible ( without using array formulas etc.) so that the raw data file remains practically unchanged with only undesirable rows hidden. Thanks.

    And also how would the above be possible using a pivot table.
    Attached Files Attached Files

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