Problem with Advanced filter in excel 2007

[KO23L]

Hello,

i cant find what Iam doing wrong, I have quiet complex table (9199 rows actually and colums from A to FE)

I wish to use just 2 columns for filtering, but i need to get few combinations of data extracted.

1st column iam using for criteria should search for like values Data1 - Data6 and combined with 2nd column which will have values like Value1 - Value3.
I need combinations:

Data1 and Value1 or Data2 and Value1 .... Data6 and Value1
or
Data1 and Value2 or Data2 and Value2 .... Data6 and Value2
or
Data1 and Value3 or Data2 and Value3 .... Data6 and Value3

All things i have tried with criteria setting resulting in filtering data of Data 1-6 with Value1

I will put there printscreens of how i have my criteria setup:

The variants of criteria a wish to search for:

The result is always all the values from DPS / SO column(s) and just KA4.01 Value from FS column

 

[KO23L]

U i should write that these are the Variants of criteria i have tried to search for (representing combination i wish to search for - understanding it that data in one row have AND between them and data in differend rows are having OR between them).

Result is always that first block of rows reffering to FC column KA4.01 is working well no matter which variant of setup is used, rows with value KA4.02 and KA5.01 in FC column never got filtered.

 

[Fluff]

Cross posted Here

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.