Spreadsheet: 274304d1383069970-challenging-complex-formula-unique-count-for-multiple-criteria-on-several-levels-problems-count-4
Sheet: Sheet1

 | Data |  |  |  |  |  |  |  | Should look like if there any problems/negative feedback
 | CP | Type | Size | Series | ok? | Date | Unique Value in type | Unique Values in Type & Size | Across type only |  |  |  |  | Across type and size
 | CP1 | c2a3334r asd | 44rwssall 12413 | CAA1 | Yes | 2013-01-02 00:00:00 | c2a3334r asd | c2a3334r asd44rwssall 12413 | time period | CP1 | CP2 | CP3 |  | time period | CP1 | CP2 | CP3
 | CP1 | c2a3334r asd | 44rwssall 12413 | CAA2 | Yes | 2013-01-02 00:00:00 | ct554e  ar ppe | c2a3334r asdythu43 etr4 | 2013-01-01 00:00:00 |  |  |  |  | 2013-01-01 00:00:00
 | CP1 | c2a3334r asd | 44rwssall 12413 | CAA3 | Yes | 2013-01-02 00:00:00 | tppde k r32as | ct554e  ar ppe9888all 7juud | 2013-02-01 00:00:00 |  |  |  |  | 2013-02-01 00:00:00
 | CP1 | c2a3334r asd | 44rwssall 12413 | CAA4 | Yes | 2013-01-02 00:00:00 | ni h434 | ct554e  ar ppe323rge 8ufe | 2013-03-01 00:00:00 |  |  |  |  | 2013-03-01 00:00:00
 | CP1 | c2a3334r asd | 44rwssall 12413 | CAA5 | Yes | 2013-01-02 00:00:00 | vaddddn kiw8 | tppde [NAME] | 2013-04-01 00:00:00 |  |  |  |  | 2013-04-01 00:00:00
 | CP1 | c2a3334r asd | 44rwssall 12413 | CAA6 | Yes | 2013-01-02 00:00:00 |  | tppde k [NAME] | 2013-05-01 00:00:00 |  |  |  |  | 2013-05-01 00:00:00
 | CP1 | c2a3334r asd | ythu43 etr4 | CAA1 | Yes | 2013-01-02 00:00:00 |  | ni h434sddsall 8890 | 2013-06-01 00:00:00 |  |  |  |  | 2013-06-01 00:00:00
 | CP1 | c2a3334r asd | ythu43 etr4 | CAA2 | Yes | 2013-01-02 00:00:00 |  | [NAME] 334fff | 2013-07-01 00:00:00 |  |  |  |  | 2013-07-01 00:00:00
 | CP1 | c2a3334r asd | ythu43 etr4 | CAA3 | Yes | 2013-01-02 00:00:00 |  | vaddddn [NAME] u8877h | 2013-08-01 00:00:00 |  |  |  |  | 2013-08-01 00:00:00
 | CP1 | c2a3334r asd | ythu43 etr4 | CAA4 | Yes | 2013-01-02 00:00:00 |  |  | 2013-09-01 00:00:00 |  |  |  |  | 2013-09-01 00:00:00
 | CP1 | c2a3334r asd | ythu43 etr4 | CAA5 | Yes | 2013-01-02 00:00:00 |  |  | 2013-10-01 00:00:00 |  |  |  |  | 2013-10-01 00:00:00
 | CP1 | c2a3334r asd | ythu43 etr4 | CAA6 | Yes | 2013-01-02 00:00:00 |  |  | 2013-11-01 00:00:00 |  |  |  |  | 2013-11-01 00:00:00
 | CP2 | ct554e  ar ppe | 9888all 7juud | CAA1 | Yes | 2013-01-31 00:00:00 |  |  | 2013-12-01 00:00:00 |  |  |  |  | 2013-12-01 00:00:00
 | CP2 | ct554e  ar ppe | 9888all 7juud | CAA2 | not fun to drive | 2013-01-31 00:00:00
 | CP2 | ct554e  ar ppe | 9888all 7juud | 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 | ct554e  ar ppe | 9888all 7juud | 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 | ct554e  ar ppe | 9888all 7juud | CAA3 | Yes | 2013-01-31 00:00:00
 | CP2 | ct554e  ar ppe | 9888all 7juud | CAA4 | Yes | 2013-01-31 00:00:00
 | CP2 | ct554e  ar ppe | 9888all 7juud | CAA5 | boring to drive | 2013-01-31 00:00:00
 | CP2 | ct554e  ar ppe | 9888all 7juud | CAA6 | Yes | 2013-01-31 00:00:00
 | CP2 | ct554e  ar ppe | 323rge 8ufe | CAA1 | Yes | 2013-01-31 00:00:00
 | CP2 | ct554e  ar ppe | 323rge 8ufe | CAA2 | Yes | 2013-01-31 00:00:00
 | CP2 | ct554e  ar ppe | 323rge 8ufe | CAA3 | too big | 2013-01-31 00:00:00
 | CP2 | ct554e  ar ppe | 323rge 8ufe | CAA4 | Yes | 2013-01-31 00:00:00
 | CP2 | ct554e  ar ppe | 323rge 8ufe | CAA5 | Yes | 2013-01-31 00:00:00
 | CP2 | ct554e  ar ppe | 323rge 8ufe | CAA6 | Yes | 2013-01-31 00:00:00
 | CP1 | tppde k r32as | sm2245all ttte | CAA1 | Yes | 2013-03-02 00:00:00
 | CP1 | tppde k r32as | sm2245all ttte | CAA2 | wont buy | 2013-03-02 00:00:00
 | CP1 | tppde k r32as | sm2245all ttte | CAA3 | boring to drive | 2013-03-02 00:00:00
 | CP1 | tppde k r32as | sm2245all ttte | CAA4 | don’t like | 2013-03-02 00:00:00
 | CP1 | tppde k r32as | sm2245all ttte | CAA4 | don’t like | 2013-03-02 00:00:00
 | CP1 | tppde k r32as | sm2245all ttte | CAA5 | smells | 2013-03-02 00:00:00
 | CP1 | tppde k r32as | sm2245all ttte | CAA5 | bumpy | 2013-03-02 00:00:00
 | CP1 | tppde k r32as | sm2245all ttte | CAA6 | Yes | 2013-03-02 00:00:00
 | CP1 | tppde k r32as | [NAME] | CAA1 | Yes | 2013-03-02 00:00:00
 | CP1 | tppde k r32as | [NAME] | CAA2 | Yes | 2013-03-02 00:00:00
 | CP1 | tppde k r32as | [NAME] | CAA3 | don’t like | 2013-03-02 00:00:00
 | CP1 | tppde k r32as | [NAME] | CAA4 | Yes | 2013-03-02 00:00:00
 | CP1 | tppde k r32as | [NAME] | CAA5 | Yes | 2013-03-02 00:00:00
 | CP1 | tppde k r32as | [NAME] | CAA6 | Yes | 2013-03-02 00:00:00
 | CP1 | ni h434 | sddsall 8890 | CAA1 | Yes | 2013-03-24 00:00:00
 | CP1 | ni h434 | sddsall 8890 | CAA2 | Yes | 2013-03-24 00:00:00
 | CP1 | ni h434 | sddsall 8890 | CAA3 | wont buy | 2013-03-24 00:00:00
 | CP1 | ni h434 | sddsall 8890 | CAA4 | Yes | 2013-03-24 00:00:00
 | CP1 | ni h434 | sddsall 8890 | CAA5 | Yes | 2013-03-24 00:00:00
 | CP1 | ni h434 | sddsall 8890 | CAA6 | Yes | 2013-03-24 00:00:00
 | CP1 | ni h434 | [NAME] | CAA1 | Yes | 2013-03-24 00:00:00
 | CP1 | ni h434 | [NAME] | CAA2 | Yes | 2013-03-24 00:00:00
 | CP1 | ni h434 | [NAME] | CAA3 | Yes | 2013-03-24 00:00:00
 | CP1 | ni h434 | [NAME] | CAA4 | Yes | 2013-03-24 00:00:00
 | CP1 | ni h434 | [NAME] | CAA5 | Yes | 2013-03-24 00:00:00
 | CP1 | ni h434 | [NAME] | CAA6 | Yes | 2013-03-24 00:00:00
 | CP1 | vaddddn kiw8 | [NAME] u8877h | CAA1 | Yes | 2013-03-24 00:00:00
 | CP1 | vaddddn kiw8 | [NAME] u8877h | CAA2 | Yes | 2013-03-24 00:00:00
 | CP1 | vaddddn kiw8 | [NAME] u8877h | CAA3 | Yes | 2013-03-24 00:00:00
 | CP1 | vaddddn kiw8 | [NAME] u8877h | CAA4 | Yes | 2013-03-24 00:00:00
 | CP1 | vaddddn kiw8 | [NAME] u8877h | CAA5 | Yes | 2013-03-24 00:00:00
 | CP1 | vaddddn kiw8 | [NAME] u8877h | CAA6 | Yes | 2013-03-24 00:00:00