Spreadsheet: 274131d1383023252-challenging-complex-formula-unique-count-for-multiple-criteria-on-several-levels-problems-count-2
Sheet: Sheet1

 | Data |  |  |  |  |  |  | Should look like if there any problems/negative feedback
 | CP | type | size | series | ok? | date |  | Across type only |  |  |  |  | Across type and size
 | CP1 | car | small | CAA1 | Yes | 2013-01-02 00:00:00 |  | time period | CP1 | CP2 | CP3 |  | time period | CP1 | CP2 | CP3
 | CP1 | car | small | CAA2 | Yes | 2013-01-02 00:00:00 |  | 2013-01-01 00:00:00 |  |  |  |  | 2013-01-01 00:00:00
 | CP1 | car | small | CAA3 | Yes | 2013-01-02 00:00:00 |  | 2013-02-01 00:00:00 |  |  |  |  | 2013-02-01 00:00:00
 | CP1 | car | small | CAA4 | Yes | 2013-01-02 00:00:00 |  | 2013-03-01 00:00:00 |  |  |  |  | 2013-03-01 00:00:00
 | CP1 | car | small | CAA5 | Yes | 2013-01-02 00:00:00 |  | 2013-04-01 00:00:00 |  |  |  |  | 2013-04-01 00:00:00
 | CP1 | car | small | CAA6 | Yes | 2013-01-02 00:00:00 |  | 2013-05-01 00:00:00 |  |  |  |  | 2013-05-01 00:00:00
 | CP1 | car | large | CAA1 | Yes | 2013-01-02 00:00:00 |  | 2013-06-01 00:00:00 |  |  |  |  | 2013-06-01 00:00:00
 | CP1 | car | large | CAA2 | Yes | 2013-01-02 00:00:00 |  | 2013-07-01 00:00:00 |  |  |  |  | 2013-07-01 00:00:00
 | CP1 | car | large | CAA3 | Yes | 2013-01-02 00:00:00 |  | 2013-08-01 00:00:00 |  |  |  |  | 2013-08-01 00:00:00
 | CP1 | car | large | CAA4 | Yes | 2013-01-02 00:00:00 |  | 2013-09-01 00:00:00 |  |  |  |  | 2013-09-01 00:00:00
 | CP1 | car | large | CAA5 | Yes | 2013-01-02 00:00:00 |  | 2013-10-01 00:00:00 |  |  |  |  | 2013-10-01 00:00:00
 | CP1 | car | large | CAA6 | Yes | 2013-01-02 00:00:00 |  | 2013-11-01 00:00:00 |  |  |  |  | 2013-11-01 00:00:00
 | CP2 | car | small | CAA1 | Yes | 2013-01-31 00:00:00 |  | 2013-12-01 00:00:00 |  |  |  |  | 2013-12-01 00:00:00
 | CP2 | car | small | CAA2 | not fun to drive | 2013-01-31 00:00:00
 | CP2 | car | small | CAA2 | uncomfortable | 2013-01-31 00:00:00 |  | NOTE: In Mar 2013, there are 3 [NAME] in Mar 2013….only 2 of them have problems (only yellow is problem free)
 | CP2 | car | small | CAA2 | too small | 2013-01-31 00:00:00 |  | NOTE: In Mar 2013, there are 5 Type and [NAME] combos in Mar 2013….but 3 of them have problems
 | CP2 | car | small | CAA3 | Yes | 2013-01-31 00:00:00
 | CP2 | car | small | CAA4 | Yes | 2013-01-31 00:00:00
 | CP2 | car | small | CAA5 | boring to drive | 2013-01-31 00:00:00
 | CP2 | car | small | CAA6 | Yes | 2013-01-31 00:00:00
 | CP2 | car | large | CAA1 | Yes | 2013-01-31 00:00:00
 | CP2 | car | large | CAA2 | Yes | 2013-01-31 00:00:00
 | CP2 | car | large | CAA3 | too big | 2013-01-31 00:00:00
 | CP2 | car | large | CAA4 | Yes | 2013-01-31 00:00:00
 | CP2 | car | large | CAA5 | Yes | 2013-01-31 00:00:00
 | CP2 | car | large | CAA6 | Yes | 2013-01-31 00:00:00
 | CP1 | truck | small | CAA1 | Yes | 2013-03-02 00:00:00
 | CP1 | truck | small | CAA2 | wont buy | 2013-03-02 00:00:00
 | CP1 | truck | small | CAA3 | boring to drive | 2013-03-02 00:00:00
 | CP1 | truck | small | CAA4 | don’t like | 2013-03-02 00:00:00
 | CP1 | truck | small | CAA4 | don’t like | 2013-03-02 00:00:00
 | CP1 | truck | small | CAA5 | smells | 2013-03-02 00:00:00
 | CP1 | truck | small | CAA5 | bumpy | 2013-03-02 00:00:00
 | CP1 | truck | small | CAA6 | Yes | 2013-03-02 00:00:00
 | CP1 | van | large | CAA1 | Yes | 2013-03-12 00:00:00
 | CP1 | van | large | CAA2 | Yes | 2013-03-12 00:00:00
 | CP1 | van | large | CAA3 | don’t like | 2013-03-12 00:00:00
 | CP1 | van | large | CAA4 | Yes | 2013-03-12 00:00:00
 | CP1 | van | large | CAA5 | Yes | 2013-03-12 00:00:00
 | CP1 | van | large | CAA6 | Yes | 2013-03-12 00:00:00
 | CP1 | mini | small | CAA1 | Yes | 2013-03-24 00:00:00
 | CP1 | mini | small | CAA2 | Yes | 2013-03-24 00:00:00
 | CP1 | mini | small | CAA3 | wont buy | 2013-03-24 00:00:00
 | CP1 | mini | small | CAA4 | Yes | 2013-03-24 00:00:00
 | CP1 | mini | small | CAA5 | Yes | 2013-03-24 00:00:00
 | CP1 | mini | small | CAA6 | Yes | 2013-03-24 00:00:00
 | CP1 | mini | medium | CAA1 | Yes | 2013-03-24 00:00:00
 | CP1 | mini | medium | CAA2 | Yes | 2013-03-24 00:00:00
 | CP1 | mini | medium | CAA3 | Yes | 2013-03-24 00:00:00
 | CP1 | mini | medium | CAA4 | Yes | 2013-03-24 00:00:00
 | CP1 | mini | medium | CAA5 | Yes | 2013-03-24 00:00:00
 | CP1 | mini | medium | CAA6 | Yes | 2013-03-24 00:00:00
 | CP1 | van | medium | CAA1 | Yes | 2013-03-24 00:00:00
 | CP1 | van | medium | CAA2 | Yes | 2013-03-24 00:00:00
 | CP1 | van | medium | CAA3 | Yes | 2013-03-24 00:00:00
 | CP1 | van | medium | CAA4 | Yes | 2013-03-24 00:00:00
 | CP1 | van | medium | CAA5 | Yes | 2013-03-24 00:00:00
 | CP1 | van | medium | CAA6 | Yes | 2013-03-24 00:00:00