Spreadsheet: 484408d1476265891-count-unique-values-while-meeting-4-criteria-s-count-unique-value-with-4-criteria
Sheet: Data

 |  |  |  |  |  |  |  |  |  |  |  |  | Week |  | Unique Item Count Needed
 |  |  |  |  |  |  |  | Segment | [NAME] | Demand Type | Type-1 |  | 44
Item | Segment | Week | Demand Type | Qty
Item-1 | Segment-3 | OD+CUR. | Type-3 | 1145
Item-1 | Segment-3 | OD+CUR. | Type-1 | 440
Item-1 | Segment-3 | OD+CUR. | Type-1 | 890 |  |  |  |  |  |  |  |  |  |  | In Column P2, I need a Unique Item Count which is meeting below 4 criteria’s…
Item-1 | Segment-3 | OD+CUR. | Type-2 | 0 |  |  |  |  |  |  |  |  |  |  | 1.     J2 – Segment (Drop Down)
Item-1 | Segment-3 | OD+CUR. | Type-2 | 0 |  |  |  |  |  |  |  |  |  |  | 2.     L2 – Demand Type (Drop Down)
Item-1 | Segment-3 | 43 | Type-2 | 395 |  |  |  |  |  |  |  |  |  |  | 3.     N2 – Week (Drop Down)
Item-1 | Segment-3 | 44 | Type-2 | 862 |  |  |  |  |  |  |  |  |  |  | 4.     [NAME] is Greater Than ZERO
Item-1 | Segment-3 | 45 | Type-2 | 173
Item-1 | Segment-3 | 46 | Type-2 | 346
Item-1 | Segment-3 | 47 | Type-2 | 287
Item-1 | Segment-3 | 48 | Type-2 | 346
Item-1 | Segment-3 | 49 | Type-2 | 172
Item-2 | Segment-3 | OD+CUR. | Type-1 | 0
Item-2 | Segment-3 | 43 | Type-2 | 195
Item-2 | Segment-3 | 44 | Type-2 | 203
Item-2 | Segment-3 | 45 | Type-2 | 25
Item-2 | Segment-3 | 46 | Type-2 | 48
Item-2 | Segment-3 | 47 | Type-2 | 40
Item-2 | Segment-3 | 48 | Type-2 | 48
Item-2 | Segment-3 | 49 | Type-2 | 24
Item-3 | Segment-3 | 44 | Type-1 | 0
Item-3 | Segment-3 | 44 | Type-1 | 105
Item-3 | Segment-3 | 44 | Type-1 | 72
Item-3 | Segment-3 | 44 | Type-1 | 108
Item-3 | Segment-3 | 44 | Type-1 | 48
Item-3 | Segment-3 | 45 | Type-1 | 48
Item-3 | Segment-3 | 46 | Type-1 | 36
Item-3 | Segment-3 | 47 | Type-1 | 96
Item-3 | Segment-3 | 47 | Type-1 | 114
Item-4 | Segment-5 | 43 | Type-1 | 24
Item-4 | Segment-5 | 44 | Type-1 | 1
Item-5 | Segment-5 | OD+CUR. | Type-3 | 1977
Item-5 | Segment-5 | 43 | Type-1 | 3774
Item-5 | Segment-5 | OD+CUR. | Type-2 | 0
Item-5 | Segment-5 | 43 | Type-2 | 0
Item-5 | Segment-5 | 44 | Type-2 | 0
Item-5 | Segment-5 | 45 | Type-2 | 500
Item-5 | Segment-5 | 46 | Type-2 | 1000
Item-5 | Segment-5 | 47 | Type-2 | 834
Item-5 | Segment-5 | 48 | Type-2 | 1000
Item-5 | Segment-5 | 49 | Type-2 | 499
Item-6 | [NAME] | 43 | Type-1 | 200
Item-6 | [NAME] | 44 | Type-1 | 200
Item-6 | [NAME] | 46 | Type-1 | 200
Item-6 | [NAME] | 47 | Type-1 | 200
Item-6 | [NAME] | 48 | Type-1 | 200
Item-6 | [NAME] | 49 | Type-1 | 200
Item-7 | [NAME] | 45 | Type-1 | 0
Item-7 | [NAME] | 46 | Type-1 | 0
Item-7 | [NAME] | 47 | Type-1 | 0
Item-7 | [NAME] | 48 | Type-1 | 0
Item-8 | [NAME] | 45 | Type-1 | 0
Item-8 | [NAME] | 47 | Type-1 | 0
Item-9 | [NAME] | OD+CUR. | Type-1 | 0
Item-9 | [NAME] | OD+CUR. | Type-1 | 0
Item-9 | [NAME] | OD+CUR. | Type-1 | 0
Item-9 | [NAME] | 43 | Type-1 | 0
Item-9 | [NAME] | 44 | Type-1 | 0
Item-9 | [NAME] | 45 | Type-1 | 0
Item-9 | [NAME] | 46 | Type-1 | 0
Item-9 | [NAME] | 47 | Type-1 | 0
Item-9 | [NAME] | 48 | Type-1 | 0
Item-9 | [NAME] | 49 | Type-1 | 0
Item-9 | [NAME] | 50 | Type-1 | 0
Item-10 | [NAME] | OD+CUR. | Type-1 | 0
Item-10 | [NAME] | 43 | Type-1 | 0
Item-10 | [NAME] | 44 | Type-1 | 50
Item-10 | [NAME] | 45 | Type-1 | 100
Item-10 | [NAME] | 46 | Type-1 | 50
Item-10 | [NAME] | 47 | Type-1 | 150
Item-10 | [NAME] | 48 | Type-1 | 100
Item-10 | [NAME] | 49 | Type-1 | 150
Item-10 | [NAME] | 50 | Type-1 | 50
Item-11 | [NAME] | 44 | Type-1 | 0
Item-11 | [NAME] | 45 | Type-1 | 0
Item-11 | [NAME] | 47 | Type-1 | 0
Item-11 | [NAME] | 48 | Type-1 | 0
Item-11 | [NAME] | 50 | Type-1 | 0
Item-12 | Segment-1 | OD+CUR. | Type-1 | 500
Item-12 | Segment-1 | 44 | Type-1 | 1000
Item-12 | Segment-1 | 47 | Type-1 | 1000
Item-12 | Segment-1 | 47 | Type-1 | 2000
Item-12 | Segment-1 | 49 | Type-1 | 1000
Item-12 | Segment-1 | 52 | Type-1 | 1000
Item-12 | Segment-1 | 45 | Type-2 | 0
Item-12 | Segment-1 | 49 | Type-2 | 0
Item-13 | Segment-1 | 50 | Type-1 | 5000
Item-13 | Segment-1 | 51 | Type-1 | 5800
Item-13 | Segment-1 | 45 | Type-2 | 360
Item-13 | Segment-1 | 49 | Type-2 | 0
Item-14 | Segment-1 | OD+CUR. | Type-1 | 200
Item-14 | Segment-1 | 45 | Type-1 | 100
Item-14 | Segment-1 | 45 | Type-1 | 300
Item-14 | Segment-1 | 51 | Type-1 | 5900
Item-14 | Segment-1 | 45 | Type-2 | 2844
Item-14 | Segment-1 | 49 | Type-2 | 0
Item-15 | [NAME] | 44 | Type-1 | 200
Item-15 | [NAME] | 45 | Type-1 | 800
Item-15 | [NAME] | 47 | Type-1 | 400
Item-15 | [NAME] | 48 | Type-1 | 400
Item-15 | [NAME] | 49 | Type-1 | 200
Item-16 | Segment-2 | 44 | Type-1 | 0
Item-17 | Segment-2 | 44 | Type-1 | 0
Item-18 | Segment-2 | 48 | Type-1 | 50
Item-19 | Segment-2 | 43 | Type-1 | 0
Item-20 | Segment-2 | 43 | Type-1 | 0
Item-20 | Segment-2 | 45 | Type-1 | 0
Item-20 | Segment-2 | 48 | Type-1 | 0
Item-21 | Segment-2 | OD+CUR. | Type-1 | 30
Item-21 | Segment-2 | OD+CUR. | Type-1 | 10
Item-21 | Segment-2 | 43 | Type-1 | 15
Item-21 | Segment-2 | 44 | Type-1 | 10
Item-21 | Segment-2 | 47 | Type-1 | 15
Item-21 | Segment-2 | 48 | Type-1 | 5
Item-22 | Segment-2 | OD+CUR. | Type-1 | 0
Item-22 | Segment-2 | 44 | Type-1 | 0
Item-23 | Segment-2 | 43 | Type-1 | 25
Item-23 | Segment-2 | 48 | Type-1 | 25
Item-24 | Segment-2 | OD+CUR. | Type-1 | 0
Item-24 | Segment-2 | 47 | Type-1 | 25
Item-25 | Segment-2 | OD+CUR. | Type-1 | 25
Item-25 | Segment-2 | 44 | Type-1 | 25
Item-25 | Segment-2 | 48 | Type-1 | 25
Item-26 | Segment-2 | OD+CUR. | Type-1 | 40
Item-26 | Segment-2 | 43 | Type-1 | 20
Item-26 | Segment-2 | 47 | Type-1 | 20
Item-27 | Segment-2 | 44 | Type-1 | 0
Item-28 | Segment-2 | OD+CUR. | Type-1 | 0
Item-29 | Segment-2 | OD+CUR. | Type-1 | 4
Item-29 | Segment-2 | 44 | Type-1 | 2
Item-30 | Segment-2 | OD+CUR. | Type-1 | 0
Item-31 | Segment-2 | OD+CUR. | Type-1 | 0
Item-31 | Segment-2 | 47 | Type-1 | 50
Item-32 | Segment-2 | OD+CUR. | Type-1 | 0
Item-32 | Segment-2 | 47 | Type-1 | 0
Item-33 | Segment-2 | OD+CUR. | Type-1 | 0
Item-33 | Segment-2 | 43 | Type-1 | 0
Item-34 | Segment-2 | 48 | Type-1 | 0
Item-35 | Segment-2 | 43 | Type-1 | 0
Item-36 | Segment-2 | OD+CUR. | Type-1 | 100
Item-36 | Segment-2 | 44 | Type-1 | 50
Item-37 | Segment-2 | OD+CUR. | Type-1 | 0
Item-37 | Segment-2 | 44 | Type-1 | 0
Item-38 | Segment-2 | OD+CUR. | Type-1 | 0
Item-39 | Segment-2 | OD+CUR. | Type-1 | 0
Item-39 | Segment-2 | 44 | Type-1 | 5
Item-40 | Segment-2 | OD+CUR. | Type-1 | 0
Item-41 | Segment-2 | OD+CUR. | Type-1 | 0
Item-41 | Segment-2 | OD+CUR. | Type-1 | 25
Item-42 | Segment-2 | 47 | Type-1 | 0
Item-43 | Segment-2 | OD+CUR. | Type-1 | 0
Item-43 | Segment-2 | 43 | Type-1 | 25
Item-43 | Segment-2 | 44 | Type-1 | 25
Item-43 | Segment-2 | 47 | Type-1 | 25
Item-43 | Segment-2 | 48 | Type-1 | 25
Item-44 | Segment-2 | 45 | Type-1 | 250
Item-45 | Segment-2 | OD+CUR. | Type-1 | 0
Item-45 | Segment-2 | OD+CUR. | Type-1 | 0
Item-45 | Segment-2 | 43 | Type-1 | 0
Item-45 | Segment-2 | 44 | Type-1 | 15
Item-45 | Segment-2 | 45 | Type-1 | 35
Item-45 | Segment-2 | 47 | Type-1 | 45
Item-45 | Segment-2 | 48 | Type-1 | 10
Item-45 | Segment-2 | 49 | Type-1 | 20
Item-46 | Segment-2 | OD+CUR. | Type-1 | 56
Item-46 | Segment-2 | OD+CUR. | Type-1 | 12
Item-46 | Segment-2 | 43 | Type-1 | 20
Item-46 | Segment-2 | 44 | Type-1 | 8
Item-46 | Segment-2 | 45 | Type-1 | 16
Item-46 | Segment-2 | 47 | Type-1 | 24
Item-46 | Segment-2 | 48 | Type-1 | 4
Item-46 | Segment-2 | 49 | Type-1 | 12
Item-47 | Segment-2 | OD+CUR. | Type-1 | 0
Item-47 | Segment-2 | 43 | Type-1 | 0
Item-47 | Segment-2 | 47 | Type-1 | 50
Item-48 | Segment-2 | OD+CUR. | Type-1 | 0
Item-48 | Segment-2 | OD+CUR. | Type-1 | 0
Item-48 | Segment-2 | 43 | Type-1 | 20
Item-48 | Segment-2 | 44 | Type-1 | 20
Item-48 | Segment-2 | 45 | Type-1 | 20
Item-48 | Segment-2 | 47 | Type-1 | 20
Item-48 | Segment-2 | 49 | Type-1 | 20
Item-49 | Segment-2 | 49 | Type-1 | 20
Item-50 | Segment-2 | OD+CUR. | Type-1 | 0
Item-50 | Segment-2 | OD+CUR. | Type-1 | 0
Item-50 | Segment-2 | OD+CUR. | Type-1 | 0
Item-50 | Segment-2 | 43 | Type-1 | 0
Item-50 | Segment-2 | 44 | Type-1 | 0
Item-50 | Segment-2 | 45 | Type-1 | 300
Item-50 | Segment-2 | 47 | Type-1 | 400
Item-50 | Segment-2 | 49 | Type-1 | 200
Item-51 | Segment-2 | OD+CUR. | Type-1 | 0
Item-51 | Segment-2 | 44 | Type-1 | 0
Item-52 | Segment-2 | 43 | Type-1 | 50
Item-52 | Segment-2 | 44 | Type-1 | 50
Item-52 | Segment-2 | 47 | Type-1 | 50
Item-52 | Segment-2 | 49 | Type-1 | 50
Item-53 | [NAME] | OD+CUR. | Type-1 | 50
Item-53 | [NAME] | 43 | Type-1 | 50
Item-53 | [NAME] | 46 | Type-1 | 50
Item-53 | [NAME] | 47 | Type-1 | 50
Item-53 | [NAME] | 48 | Type-1 | 50
Item-54 | [NAME] | OD+CUR. | Type-1 | 50
Item-54 | [NAME] | 43 | Type-1 | 50
Item-54 | [NAME] | 44 | Type-1 | 50
Item-54 | [NAME] | 47 | Type-1 | 50
Item-54 | [NAME] | 48 | Type-1 | 50
Item-55 | [NAME] | 43 | Type-1 | 0
Item-55 | [NAME] | 44 | Type-1 | 0
Item-55 | [NAME] | 46 | Type-1 | 50
Item-55 | [NAME] | 47 | Type-1 | 100
Item-55 | [NAME] | 48 | Type-1 | 100
Item-56 | [NAME] | 47 | Type-1 | 0
Item-57 | [NAME] | 43 | Type-1 | 0
Item-57 | [NAME] | 47 | Type-1 | 100
Item-58 | [NAME] | 46 | Type-1 | 100
Item-58 | [NAME] | 47 | Type-1 | 200
Item-58 | [NAME] | 49 | Type-1 | 200
Item-59 | [NAME] | 43 | Type-1 | 0
Item-59 | [NAME] | 44 | Type-1 | 100
Item-59 | [NAME] | 45 | Type-1 | 100
Item-59 | [NAME] | 46 | Type-1 | 150
Item-59 | [NAME] | 47 | Type-1 | 600
Item-59 | [NAME] | 49 | Type-1 | 600
Item-60 | [NAME] | 46 | Type-1 | 0
Item-60 | [NAME] | 47 | Type-1 | 0
Item-60 | [NAME] | 49 | Type-1 | 200
Item-61 | [NAME] | 47 | Type-1 | 0
Item-62 | [NAME] | 45 | Type-1 | 0
Item-62 | [NAME] | 49 | Type-1 | 0
Item-62 | [NAME] | 50 | Type-1 | 0
Item-63 | [NAME] | 48 | Type-1 | 0
Item-64 | [NAME] | 44 | Type-1 | 0
Item-64 | [NAME] | 48 | Type-1 | 0
Item-65 | [NAME] | 47 | Type-1 | 0
Item-65 | [NAME] | 48 | Type-1 | 0
Item-66 | [NAME] | 47 | Type-1 | 0
Item-66 | [NAME] | 48 | Type-1 | 0
Item-67 | [NAME] | 47 | Type-1 | 0
Item-67 | [NAME] | 48 | Type-1 | 0
Item-68 | [NAME] | 44 | Type-1 | 0
Item-68 | [NAME] | 48 | Type-1 | 0
Item-69 | [NAME] | 47 | Type-1 | 0
Item-69 | [NAME] | 48 | Type-1 | 0
Item-70 | [NAME] | 45 | Type-1 | 0
Item-70 | [NAME] | 47 | Type-1 | 0
Item-70 | [NAME] | 48 | Type-1 | 0
Item-71 | [NAME] | 47 | Type-1 | 0
Item-72 | [NAME] | 47 | Type-1 | 0
Item-72 | [NAME] | 48 | Type-1 | 0
Item-73 | [NAME] | 44 | Type-1 | 0
Item-73 | [NAME] | 47 | Type-1 | 0
Item-74 | [NAME] | 47 | Type-1 | 0
Item-75 | [NAME] | 43 | Type-1 | 0
Item-75 | [NAME] | 47 | Type-1 | 0
Item-76 | [NAME] | OD+CUR. | Type-1 | 0
Item-76 | [NAME] | 43 | Type-1 | 0
Item-76 | [NAME] | 44 | Type-1 | 0
Item-76 | [NAME] | 45 | Type-1 | 0
Item-76 | [NAME] | 46 | Type-1 | 0
Item-76 | [NAME] | 47 | Type-1 | 50
Item-76 | [NAME] | 48 | Type-1 | 600
Item-77 | [NAME] | 44 | Type-1 | 50
Item-77 | [NAME] | 47 | Type-1 | 50
Item-78 | [NAME] | 45 | Type-1 | 0
Item-78 | [NAME] | 46 | Type-1 | 0
Item-78 | [NAME] | 47 | Type-1 | 0
Item-78 | [NAME] | 48 | Type-1 | 0
Item-79 | [NAME] | OD+CUR. | Type-1 | 0
Item-79 | [NAME] | 43 | Type-1 | 0
Item-79 | [NAME] | 45 | Type-1 | 0
Item-79 | [NAME] | 47 | Type-1 | 0
Item-79 | [NAME] | 48 | Type-1 | 0
Item-80 | [NAME] | 47 | Type-1 | 100
Item-81 | [NAME] | 46 | Type-1 | 100
Item-82 | [NAME] | 46 | Type-1 | 50
Item-82 | [NAME] | 47 | Type-1 | 150