Spreadsheet: 845029d1696593084-formular-to-remove-duplicate-values-then-count-based-on-another-condition-test-example
Sheet: Sheet1

 |  |  | Column 1 | Column 2 | Column 3
First 1 | Second 1 | Third 1 | Master 1 | Child 1 | Test-01
First 1 | Second 1 | Third 1 | Master 1 | Child 2 | Test-02
First 1 | Second 2 | Third 2 | Master 1 | Child 3 | Test-02
First 1 | Second 1 | Third 1 | Master 1 | Child 4 | Test-02
First 1 | Second 2 | Third 2 | Master 1 | Child 5 | Test-02
First 1 | Second 1 | Third 1 | Master 1 | Child 6 | Test-01
First 1 | Second 1 | Third 1 | Master 1 | Child 7 | Test-01
First 1 | Second 2 | Third 2 | Master 1 | Child 8 | Test-01
First 1 | Second 1 | Third 1 | Master 1 | Child 9 | Test-01
First 1 | Second 1 | Third 1 | Master 1 | Child 10 | Test-03
First 1 | Second 3 | Third 2 | Master 1 | Child 11 | Test-03
First 1 | Second 1 | Third 1 | Master 1 | Child 11 | Test-03
First 1 | Second 2 | Third 2 | Master 1 | Child 12 | Test-01
First 1 | Second 3 | Third 2 | Master 1 | Child 13 | Test-01
First 1 | Second 1 | Third 1 | Master 1 | Child 14 | Test-01
First 1 | Second 1 | Third 1 | Master 1 | Child 15 | Test-01
First 1 | Second 2 | Third 2 | Master 1 | Child 16 | Test-01
First 1 | Second 1 | Third 1 | Master 1 | Child 17 | Test-03
First 1 | Second 2 | Third 2 | Master 1 | Child 18 | Test-03
First 1 | Second 1 | Third 1 | Master 1 | Child 19 | Test-02
First 1 | Second 1 | Third 1 | Master 1 | Child 20 | Test-01
First 1 | Second 2 | Third 2 | Master 1 | Child 21 | Test-01
First 1 | Second 4 | Third 3 | Master 1 | Child 22 | Test-01
First 1 | Second 4 | Third 3 | Master 1 | Child 23 | Test-02
First 1 | Second 3 | Third 2 | Master 1 | Child 24 | Test-02
First 1 | Second 1 | Third 1 | Master 1 | Child 25 | Test-02
First 1 | Second 2 | Third 2 | Master 1 | Child 26 | Test-01
First 1 | Second 3 | Third 2 | Master 1 | Child 27 | Test-01
 |  |  | Master 1 | Child 28 | Test-01
 |  |  | Master 1 | Child 29 | Test-01
 |  |  | Master 1 | Child 30 | Test-01
 |  |  | Master 1 | Child 31 | Test-01
 |  |  | Master 1 | Child 32 | Test-01
 |  |  | Master 1 | Child 33 | Test-01
 |  |  | Master 1 | Child 34 | Test-01
 |  |  | Master 1 | Child 35 | Test-01
 |  |  | Master 1 | Child 36 | Test-01
 |  |  | Master 1 | Child 37 | Test-01
 |  |  | Master 1 | Child 38 | Test-01
 |  |  | Master 1 | Child 39 | Test-01
 |  |  | Master 1 | Child 40 | Test-01
 |  |  | Master 1 | Child 41 | Test-01
 |  |  | Master 1 | Child 42 | Test-01
 |  |  | Master 1 | Child 43 | Test-01
 |  |  | Master 1 | Child 44 | Test-01
 |  |  | Master 1 | Child 45 | Test-01
 |  |  | Master 1 | Child 46 | Test-01
 |  |  | Master 1 | Child 47 | Test-01
 |  |  | Master 1 | Child 48 | Test-01
 |  |  | Master 1 | Child 49 | Test-01
 |  |  | Master 1 | Child 50 | Test-01
 |  |  | Master 1 | Child 51 | Test-01
 |  |  | Master 1 | Child 52 | Test-01
 |  |  | Master 1 | Child 53 | Test-03
 |  |  | Master 1 | Child 54 | Test-03
 |  |  | Master 1 | Child 55 | Test-03
 |  |  | Master 1 | Child 35 | Test-01
 |  |  | Master 1 | Child 56 | Test-03
 |  |  | Master 1 | Child 57 | Test-03
 |  |  | Master 1 | Child 42 | Test-01
 |  |  | Master 2 | Child 1 | Test-01
 |  |  | Master 2 | Child 2 | Test-02
 |  |  | Master 2 | Child 3 | Test-02
 |  |  | Master 2 | Child 4 | Test-02
 |  |  | Master 2 | Child 5 | Test-02
 |  |  | Master 2 | Child 6 | Test-01
 |  |  | Master 2 | Child 7 | Test-01
 |  |  | Master 2 | Child 8 | Test-01
 |  |  | Master 2 | Child 9 | Test-01
 |  |  | Master 2 | Child 10 | Test-03
 |  |  | Master 2 | Child 11 | Test-03
 |  |  | Master 2 | Child 11 | Test-03
 |  |  | Master 2 | Child 12 | Test-01
 |  |  | Master 2 | Child 13 | Test-01
 |  |  | Master 2 | Child 14 | Test-01
 |  |  | Master 2 | Child 15 | Test-01
 |  |  | Master 2 | Child 16 | Test-01
 |  |  | Master 2 | Child 17 | Test-03
 |  |  | Master 2 | Child 18 | Test-03
 |  |  | Master 2 | Child 19 | Test-02
 |  |  | Master 2 | Child 20 | Test-01
 |  |  | Master 2 | Child 21 | Test-01
 |  |  | Master 2 | Child 22 | Test-01
 |  |  | Master 2 | Child 23 | Test-02
 |  |  | Master 2 | Child 24 | Test-02
 |  |  | Master 2 | Child 25 | Test-02