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.

I'm trying to understand your problem..

If my understanding is correct,
Account A has category 0,1,2,3,4,5,6,7

In a report, u JUST wanna show the "Rechnungsbetrag" for account A in Category 2,3,4,5,6,7 (all of this to be done my multiple filters)


Right?


Cause if that's what u want, then just Look at the attachment..
The most awesome thing about PIVOTABLE is that you can personalize it to your own reading by filtering the grey boxes(just check/uncheck your needs)..
I can see that you're gonna have a lot of datas, so learn to play around PIVOTABLE. It will definitely be useful..