Spreadsheet: 674313d1587751555-frequency-formula-with-criteria-when-filtered-test
Sheet: Watsons FOC Mar'20

 | PO | POFOC | Delivery Date | 277160
 |  |  |  | Extra Care Total Repair 19+ Shampoo 400ml
 | 16024708 | FOC 16026887 | 22.02.20 | 36 | 36
 | 16030175 | FOC 16031191 | 26.02.20 | 120 | 120
 | 16038714 | FOC 16042629 | 02.03.20 | 84 | 84
 | 16043254 | FOC 16044693 | 04.03.20 | 252 | 252
 | 16052417 | FOC 16053987 | 07.03.20 | 36 | 36
 | 16054415 | FOC 16054414 | 07.03.20 | 24 | 24
 | 16057480 | FOC 16058791 | 11.03.20 | 60 | 60
 | 16065919 | FOC 16069087 | 14.03.20 | 36 | 36
 | 16070523 | FOC 16070522 | 18.03.20 | 12 | 12
 | 16082110 | FOC 16086287 | 21.03.20 | 36 | 36
 | 16087917 | FOC 16088991 | 25.03.20 | 24 | 24
 |  |  |  | 277161
 |  |  |  | Extra Care Total Repair 19+ Conditioner 400ml
 | 16030175 | FOC 16031191 | 26.02.20 | 60 | 60
 | 16038714 | FOC 16042629 | 02.03.20 | 36 | 36 |  | 16082110 | 4002888872 | 8002974737 | FOC 16086287 | 24
 | 16043254 | FOC 16044693 | 04.03.20 | 108 | 108
 | 16052417 | FOC 16053987 | 07.03.20 | 36 | 36
 | 16057480 | FOC 16058791 | 11.03.20 | 36 | 36
 | 16065919 | FOC 16069087 | 14.03.20 | 48 | 48
 |  |  |  | 258201
 |  |  |  | Extra Care Deep Repair Shampoo 400ml
 | 16024708 | FOC 16026887 | 22.02.20 | 198 | 198
 | 16027995 | FOC 16027994 | 26.02.20 | 6 | 6
 | 16030175 | FOC 16031191 | 26.02.20 | 612 | 612
 | 16032403 | FOC 16032402 | 26.02.20 | 138 | 138
 | 16038714 | FOC 16042629 | 02.03.20 | 54 | 54
 | 16043254 | FOC 16044693 | 04.03.20 | 396 | 396
 | 16032300 | FOC 16032299 | 26.02.20 | 1986 | 1986
 | 16072650 | FOC 16073492 | 18.03.20 | 162 | 162
 | 16082110 | FOC 16086287 | 21.03.20 | 120 | 120
 |  |  |  | 3,672.00 | 3,672.00
 |  |  |  | 258202
 |  |  |  | Extra Care Deep Repair Conditioner 400ml
 | 16024708 | FOC 16026887 | 22.02.20 | 48 | 48 |  | 16072650 | 4002884232 | 8002971626 | FOC 16073492 | 78
 | 16030175 | FOC 16031191 | 26.02.20 | 78 | 78 |  | 16082110 | 4002888872 | 8002974737 | FOC 16086287 | 72
 | 16032403 | FOC 16032402 | 26.02.20 | 102 | 102
 | 16038714 | FOC 16042629 | 02.03.20 | 150 | 150
 | 16043254 | FOC 16044693 | 04.03.20 | 378 | 378
 |  |  |  | 756 | 756
 |  |  |  | 277158 |  |  |  |  |  |  |  | 120
 |  |  |  | Extra Care Ultimate Oil Elixir Shampoo 400ml |  |  |  |  |  |  |  | 180
 | 16024708 | FOC 16026887 | 22.02.20 | 120 | 120 |  |  |  |  |  |  | 408
 | 16030175 | FOC 16031191 | 26.02.20 | 180 | 180 |  |  |  |  |  |  | 24
 | 16032300 | FOC 16032299 | 26.02.20 | 408 | 408 |  | 16072650 | 4002884232 | 8002971626 | FOC 16073492 | 48 | 192
 | 16032403 | FOC 16032402 | 26.02.20 | 24 | 24 |  | 16082110 | 4002888872 | 8002974737 | FOC 16086287 | 24 | 36
 | 16043254 | FOC 16044693 | 04.03.20 | 192 | 192
 | 16038714 | FOC 16042629 | 02.03.20 | 36 | 36
 |  |  |  | 1,020.00 | 1,020.00
 |  |  |  | 277159
 |  |  |  | Extra Care Ultimate Oil Elixir Conditioner 400ml
 | 16030175 | FOC 16031191 | 26.02.20 | 108 | 108
 | 16038714 | FOC 16042629 | 02.03.20 | 84 | 84
 | 16043254 | FOC 16044693 | 04.03.20 | 144 | 144 |  | 16082110 | 4002888872 | 8002974737 | FOC 16086287 | 24
 | 16052417 | FOC 16053987 | 07.03.20 | 72 | 72
 | 16057480 | FOC 16058791 | 11.03.20 | 96 | 96
 | 16065919 | FOC 16069087 | 14.03.20 | 60 | 60
 | 16072650 | FOC 16073492 | 18.03.20 | 36 | 36
 |  |  |  | 600 | 600
 |  |  |  | 264656
 |  |  |  | Extra Care Purify & Protect Shampoo 400ml
 | 16030175 | FOC 16031191 | 26.02.20 | 12 | 12
 | 16032300 | FOC 16032299 | 26.02.20 | 198 | 198
 | 16032403 | FOC 16032402 | 26.02.20 | 150 | 150
 | 16043254 | FOC 16044693 | 04.03.20 | 6 | 6
 | 16052417 | FOC 16053987 | 07.03.20 | 54 | 54
 | 16065919 | FOC 16069087 | 14.03.20 | 6 | 6
 | 16072650 | FOC 16073492 | 18.03.20 | 24 | 24
 |  |  |  | 450 | 450
 |  |  |  | 270008
 |  |  |  | Extra Care 8 Precious Oil Shampoo 400ml
 | 16032403 | FOC 16032402 | 26.02.20 | 24 | 24
 | 16038714 | FOC 16042629 | 02.03.20 | 12 | 12
 | 16043254 | FOC 16044693 | 04.03.20 | 24 | 24
 | 16052417 | FOC 16053987 | 07.03.20 | 48 | 48 |  | 16072650 | 4002884232 | 8002971626 | FOC 16073492 | 24
 | 16054415 | FOC 16054414 | 07.03.20 | 12 | 12
 | 16057480 | FOC 16058791 | 11.03.20 | 24 | 24
 | 16082110 | FOC 16086287 | 21.03.20 | 12 | 12
 |  |  |  | 168 | 168
 |  |  |  | 270009
 |  |  |  | Extra Care 8 Precious Oil Conditioner 400ml
 | 16032403 | FOC 16032402 | 26.02.20 | 12 | 12
 | 16038714 | FOC 16042629 | 02.03.20 | 12 | 12
 | 16043254 | FOC 16044693 | 04.03.20 | 12 | 12
 | 16057480 | FOC 16058791 | 11.03.20 | 12 | 12
 | 16065919 | FOC 16069087 | 14.03.20 | 12 | 12
 | 16052417 | FOC 16053987 | 07.03.20 | 36 | 36
 |  |  |  | 96 | 96
 |  |  |  | 271165
 |  |  |  | Extra Care Airy Biotin Repair Shampoo 400ml
 | 16024708 | FOC 16026887 | 22.02.20 | 120 | 120
 | 16030175 | FOC 16031191 | 26.02.20 | 264 | 264 |  | 16038714 | 4002865766 | 8002950165 | FOC 16042629 | 36
 | 16032300 | FOC 16032299 | 26.02.20 | 576 | 576 |  | 16072650 | 4002884232 | 8002971626 | FOC 16073492 | 24
 | 16032403 | FOC 16032402 | 26.02.20 | 288 | 288 |  | 16082110 | 4002888872 | 8002974737 | FOC 16086287 | 12
 |  |  |  | 1248 | 1248
 |  |  |  | 271166
 |  |  |  | Extra Care Airy Biotin Repair Conditioner 400ml
 | 16024708 | FOC 16026887 | 22.02.20 | 60 | 60
 | 16030175 | FOC 16031191 | 26.02.20 | 72 | 72
 | 16032403 | FOC 16032402 | 26.02.20 | 24 | 24
 | 16038714 | FOC 16042629 | 02.03.20 | 72 | 72
 | 16043254 | FOC 16044693 | 04.03.20 | 96 | 96
 | 16052417 | FOC 16053987 | 07.03.20 | 60 | 60
 | 16057480 | FOC 16058791 | 11.03.20 | 48 | 48
 | 16065919 | FOC 16069087 | 14.03.20 | 48 | 48
 | 16072650 | FOC 16073492 | 18.03.20 | 12 | 12
 | 16082110 | FOC 16086287 | 21.03.20 | 12 | 12
 | 16087917 | FOC 16088991 | 25.03.20 | 12 | 12
 |  |  |  | 516 | 516