Spreadsheet: 805619d1668791827-count-unique-values-with-multiple-criteria-countifs-formula-help
Sheet: Scanning stores

Shopper Activity |  | Base | Base | Base | Base | Base | Base | Base/Promo | Promo
 | W/C | 2020-03-09 00:00:00 | 2020-03-16 00:00:00 | 2020-03-23 00:00:00 | 2020-03-30 00:00:00 | 2020-04-06 00:00:00 | 2020-04-13 00:00:00 | 2020-04-20 00:00:00 | 2020-04-27 00:00:00
Sku | Description | Units | Units | Units | Units | Units | Units | Units | Units
87863162 | OPPO VANILLA PECAN ICE CREAM 475ML
87884491 | OPPO DOUBLE SLTDCARAMEL ICE CREAM 475ML
87896678 | OPPO COLMBIAN CHOC & H/NUT ICE CREAM 475ML
88629073 | Oppo Caramel Chocolate Crunch Ice Cream 475Ml
88898686 | Oppo Double Chocolate Brownie Ice Cream 475Ml
90718110 | Oppo Double Sltd Caramel Swirl Ice Cream 475ml
90722570 | [NAME]
90778130 | Oppo Double Choc Brownie Ice Cream 475ml
88898686/90778130 | Oppo Double Choc Brownie Ice Cream 475ml
87884491/90718110 | Oppo Double Sltd Caramel Swirl Ice Cream 475ml
89912726 | Oppo Brothers 12 Sltd Crmel I/Crm Balls 168ml
Sku | Description | £ | £ | £ | £ | £ | £ | £ | £
87863162 | OPPO VANILLA PECAN ICE CREAM 475ML
87884491 | OPPO DOUBLE SLTDCARAMEL ICE CREAM 475ML
87896678 | OPPO COLMBIAN CHOC & H/NUT ICE CREAM 475ML
88629073 | Oppo Caramel Chocolate Crunch Ice Cream 475Ml
88898686 | Oppo Double Chocolate Brownie Ice Cream 475Ml
90718110 | Oppo Double Sltd Caramel Swirl Ice Cream 475ml
90722570 | [NAME]
90778130 | Oppo Double Choc Brownie Ice Cream 475ml
88898686/90778130 | Oppo Double Choc Brownie Ice Cream 475ml
87884491/90718110 | Oppo Double Sltd Caramel Swirl Ice Cream 475ml
89912726 | Oppo Brothers 12 Sltd Crmel I/Crm Balls 168ml
Sku | Description | Ranged Stores | Ranged Stores | Ranged Stores | Ranged Stores | Ranged Stores | Ranged Stores | Ranged Stores | Ranged Stores
87863162 | OPPO VANILLA PECAN ICE CREAM 475ML | 319
87884491 | OPPO DOUBLE SLTDCARAMEL ICE CREAM 475ML | 512
87896678 | OPPO COLMBIAN CHOC & H/NUT ICE CREAM 475ML | 512
88629073 | Oppo Caramel Chocolate Crunch Ice Cream 475Ml
88898686 | Oppo Double Chocolate Brownie Ice Cream 475Ml
90718110 | Oppo Double Sltd Caramel Swirl Ice Cream 475ml
90722570 | [NAME]
90778130 | Oppo Double Choc Brownie Ice Cream 475ml
88898686/90778130 | Oppo Double Choc Brownie Ice Cream 475ml
87884491/90718110 | Oppo Double Sltd Caramel Swirl Ice Cream 475ml
89912726 | Oppo Brothers 12 Sltd Crmel I/Crm Balls 168ml
Sku | Description | Unit ROS | Unit ROS | Unit ROS | Unit ROS | Unit ROS | Unit ROS | Unit ROS | Unit ROS
87863162 | OPPO VANILLA PECAN ICE CREAM 475ML
87884491 | OPPO DOUBLE SLTDCARAMEL ICE CREAM 475ML
87896678 | OPPO COLMBIAN CHOC & H/NUT ICE CREAM 475ML
88629073 | Oppo Caramel Chocolate Crunch Ice Cream 475Ml
88898686 | Oppo Double Chocolate Brownie Ice Cream 475Ml
90718110 | Oppo Double Sltd Caramel Swirl Ice Cream 475ml
90722570 | [NAME]
90778130 | Oppo Double Choc Brownie Ice Cream 475ml
88898686/90778130 | Oppo Double Choc Brownie Ice Cream 475ml
87884491/90718110 | Oppo Double Sltd Caramel Swirl Ice Cream 475ml
89912726 | Oppo Brothers 12 Sltd Crmel I/Crm Balls 168ml
 | Overall Icecream ROS
Sku | Description | Number of Scanning Stores | Number of Scanning Stores | Number of Scanning Stores | Number of Scanning Stores | Number of Scanning Stores | Number of Scanning Stores | Number of Scanning Stores | Number of Scanning Stores
87863162 | VANILLA PECAN
87884491 | DOUBLE SLTDCARAMEL
87896678 | COLMBIAN CHOC & H/NUT
88629073 | Caramel Chocolate Crunch
88898686 | Double Chocolate Brownie
90718110 | Double Sltd Caramel Swirl
90722570 | [NAME]
90778130 | Double Choc Brownie
88898686/90778130 | Double Choc Brownie 1
87884491/90718110 | Double Sltd Caramel
89912726 | 12 Sltd Crmel
Sku | Description | ASP | ASP | ASP | ASP | ASP | ASP | ASP | ASP
87863162 | OPPO VANILLA PECAN ICE CREAM 475ML
87884491 | OPPO DOUBLE SLTDCARAMEL ICE CREAM 475ML
87896678 | OPPO COLMBIAN CHOC & H/NUT ICE CREAM 475ML
88629073 | Oppo Caramel Chocolate Crunch Ice Cream 475Ml
88898686 | Oppo Double Chocolate Brownie Ice Cream 475Ml
90718110 | Oppo Double Sltd Caramel Swirl Ice Cream 475ml
90722570 | [NAME]
90778130 | Oppo Double Choc Brownie Ice Cream 475ml
88898686/90778130 | Oppo Double Choc Brownie Ice Cream 475ml
87884491/90718110 | Oppo Double Sltd Caramel Swirl Ice Cream 475ml
89912726 | Oppo Brothers 12 Sltd Crmel I/Crm Balls 168ml
Sku | Description | Availability | Availability | Availability | Availability | Availability | Availability | Availability | Availability
87863162 | OPPO VANILLA PECAN ICE CREAM 475ML
87884491 | OPPO DOUBLE SLTDCARAMEL ICE CREAM 475ML
87896678 | OPPO COLMBIAN CHOC & H/NUT ICE CREAM 475ML
88629073 | Oppo Caramel Chocolate Crunch Ice Cream 475Ml
88898686 | Oppo Double Chocolate Brownie Ice Cream 475Ml
90718110 | Oppo Double Sltd Caramel Swirl Ice Cream 475ml
90722570 | [NAME]
90778130 | Oppo Double Choc Brownie Ice Cream 475ml
88898686/90778130 | Oppo Double Choc Brownie Ice Cream 475ml
87884491/90718110 | Oppo Double Sltd Caramel Swirl Ice Cream 475ml
89912726 | Oppo Brothers 12 Sltd Crmel I/Crm Balls 168ml
GR | Gross Revenue | GR | GR | GR | GR | GR | GR | GR | GR
 | 500ml
% | Redemtion (Club Card Promo) | % | % | % | % | % | % | % | %