Spreadsheet: 693381d1598949946-consolidating-duplicate-values-pq-excelforum-sort-b-aligw
Sheet: Sheet3

PRODUCT | VAT | VAT RATE | PID | AMOUNT | PRICE | TOTAL | COST VAT EXCL | PROFIT
Delivery Cutlery (per set) | 0.26 | 7 | EX1 | 2 | 2 | 4 | 0 | 3.74
[NAME] | 255.79 | 7 | CT5 | 58 | 95 | 3970 | 0 | 3710.28
Mayo | 6.54 | 7 | [NAME] | 6 | 30 | 110 | 0 | 102.81
Fresh Marinated Onion 50g | 7.85 | 7 | AT1 | 12 | 10 | 120 | 0 | 112.15
Americano Large | 31.07 | 7 | CT4 | 11 | 125 | 565 | 0 | 528.04
Fresh Orange Juice | 144.58 | 7 | [NAME] | 98 | 375 | 3570 | 0 | 3336.46
[NAME] | 2.62 | 7 | [NAME] | 2 | 20 | 40 | 0 | 37.38
Lucky 13 Latte | 248.6 | 7 | CT11 | 51 | 160 | 4060 | 0 | 3794.38
Egg (1) | 16.36 | 7 | AT21 | 10 | 25 | 250 | 0 | 233.64
[NAME] | 11.78 | 7 | ASD11 | 6 | 30 | 180 | 0 | 168.22
[NAME] | 3.93 | 7 | [NAME] | 2 | 30 | 60 | 0 | 56.07
Choron Dressing | 11.78 | 7 | ASD25 | 6 | 30 | 180 | 0 | 168.22
Home Ketchup | 3.93 | 7 | ASD5 | 2 | 30 | 60 | 0 | 56.07
Chili Sauce | 13.74 | 7 | ASD7 | 7 | 30 | 210 | 0 | 196.26
[NAME] | 17.66 | 7 | ASD9 | 9 | 30 | 270 | 0 | 252.34
Lucky Water | 217.85 | 7 | DKS1 | 113 | 110 | 3410 | 0 | 3186.91
Mild Soft Cheese 1sl | 20.61 | 7 | AC1 | 9 | 35 | 315 | 0 | 294.39
Bacon 2Pcs | 20.61 | 7 | AM15 | 9 | 35 | 315 | 0 | 294.39
[NAME] | 9.16 | 7 | ASD17 | 4 | 35 | 140 | 0 | 130.84
Caesar Dressing | 4.58 | 7 | ASD19 | 2 | 35 | 70 | 0 | 65.42
Grilled Onion 50g | 16.03 | 7 | AT8 | 7 | 35 | 245 | 0 | 228.97
[NAME] | 45.79 | 7 | DKS3 | 20 | 35 | 700 | 0 | 654.21
Emmentaler 1sl | 18.32 | 7 | AC3 | 7 | 40 | 280 | 0 | 261.68
Avocado 1/4 | 99.44 | 7 | AT16 | 38 | 40 | 1520 | 0 | 1420.56
Eggs (2) | 7.85 | 7 | AT22 | 3 | 40 | 120 | 0 | 112.15
[NAME] | 41.87 | 7 | BE1 | 9 | 120 | 680 | 0 | 635.51
Leo | 20.93 | 7 | BE14 | 7 | 200 | 440 | 0 | 411.21
Country Loaf | 11.78 | 7 | BK10 | 3 | 40 | 180 | 0 | 168.22
Panini | 31.4 | 7 | BK7X | 12 | 40 | 480 | 0 | 448.6
[NAME] | 47.1 | 7 | CT14 | 10 | 160 | 880 | 0 | 822.43
[NAME] | 15.7 | 7 | DKS10 | 6 | 40 | 240 | 0 | 224.3
Tonic Water | 2.62 | 7 | DKS11 | 1 | 40 | 40 | 0 | 37.38
Coke | 128.22 | 7 | DKS4 | 52 | 90 | 2110 | 0 | 1971.97
Coke Zero | 81.12 | 7 | DKS6 | 31 | 40 | 1240 | 0 | 1158.88
Fanta Orange | 31.4 | 7 | [NAME] | 12 | 40 | 480 | 0 | 448.6
Fanta Red | 15.7 | 7 | [NAME] | 6 | 40 | 240 | 0 | 224.3
Sprite | 60.19 | 7 | DKS9 | 23 | 40 | 920 | 0 | 859.81
Lemonade Soda | 32.38 | 7 | SFS3 | 9 | 325 | 721 | 0 | 673.8299999999999
[NAME] 50g | 58.88 | 7 | AM3 | 18 | 50 | 900 | 0 | 841.12
Singha | 123.64 | 7 | BE3 | 22 | 140 | 1940 | 0 | 1813.09
Evian Water | 76.54 | 7 | DKS2 | 22 | 390 | 1620 | 0 | 1514.03
Red Bull | 3.27 | 7 | OPEN1 | 1 | 50 | 50 | 0 | 46.73
Croissant | 13.08 | 7 | PM1 | 4 | 50 | 200 | 0 | 186.92
[NAME] | 21.59 | 7 | AT7 | 6 | 55 | 330 | 0 | 308.41
Pain Au Chocolat | 13.74 | 7 | PM2 | 4 | 125 | 265 | 0 | 247.66
Mango Soda | 38.86 | 7 | SFS1 | 7 | 158 | 653 | 0 | 610.28
Passion Fruit Soda | 77.72 | 7 | SFS2 | 21 | 453 | 1719 | 0 | 1606.54
[NAME] | 12.95 | 7 | SFS4 | 3 | 158 | 257 | 0 | 240.19
[NAME] | 32.38 | 7 | SFS5 | 7 | 217 | 613 | 0 | 572.9
[NAME]g | 15.7 | 7 | AC5 | 4 | 60 | 240 | 0 | 224.3
Bacon 4Pcs | 11.78 | 7 | AM16 | 3 | 60 | 180 | 0 | 168.22
[NAME] (2) | 3.93 | 7 | AM6 | 1 | 60 | 60 | 0 | 56.07
[NAME] | 23.55 | 7 | CT17 | 6 | 60 | 360 | 0 | 336.45
Thai Iced Tea | 19.63 | 7 | CT18 | 5 | 60 | 300 | 0 | 280.37
[NAME] | 35.33 | 7 | PM3 | 9 | 60 | 540 | 0 | 504.67
[NAME] | 3.93 | 7 | PM4 | 1 | 60 | 60 | 0 | 56.07
[NAME] | 31.4 | 7 | XPM3 | 8 | 60 | 480 | 0 | 448.6
[NAME] | 7.85 | 7 | XPM4 | 2 | 60 | 120 | 0 | 112.15
Heineken | 64.77 | 7 | BE4 | 10 | 180 | 1060 | 0 | 990.65
Espresso | 45.79 | 7 | CT1 | 10 | 70 | 700 | 0 | 654.21
Tea - English Breakfast | 41.21 | 7 | CT16a | 9 | 70 | 630 | 0 | 588.79
Tea - Earl Grey | 18.32 | 7 | CT16b | 4 | 70 | 280 | 0 | 261.68
Tea - Green | 18.32 | 7 | CT16c | 4 | 70 | 280 | 0 | 261.68
Tea - Jasmine | 9.16 | 7 | CT16d | 2 | 70 | 140 | 0 | 130.84
Hot Chocolate | 27.48 | 7 | CT19 | 6 | 70 | 420 | 0 | 392.52
French Fries | 416.73 | 7 | XSD3 | 92 | 190 | 6490 | 0 | 6065.42
Avocado 1/2 | 36.64 | 7 | AT17 | 7 | 80 | 560 | 0 | 523.36
Iced Chocolate | 15.7 | 7 | CT20 | 3 | 80 | 240 | 0 | 224.3
Americano Small | 193.64 | 7 | CT3 | 37 | 80 | 2960 | 0 | 2766.36
Falafel Balls | 5.23 | 7 | XSD2 | 1 | 80 | 80 | 0 | 74.77
Premium Cheese Fries | 637.85 | 7 | XSD5 | 84 | 790 | 11270 | 0 | 10532.71
Wings & Fries | 461.21 | 7 | XSD6 | 56 | 630 | 7770 | 0 | 7261.69
[NAME] | 35.33 | 7 | CT12 | 6 | 90 | 540 | 0 | 504.67
[NAME] | 23.55 | 7 | CT7 | 4 | 90 | 360 | 0 | 336.45
[NAME] | 23.55 | 7 | CT9 | 4 | 90 | 360 | 0 | 336.45
[NAME] (3 pcs) | 388.6 | 7 | XSD4 | 66 | 90 | 5940 | 0 | 5551.4
Espresso Large | 12.43 | 7 | CT2 | 2 | 95 | 190 | 0 | 177.57
PROMO C&B SW | 77.72 | 7 | XSW1 | 12 | 99 | 1188 | 0 | 1110.28
PROMO [NAME] | 110.1 | 7 | XWR1 | 17 | 99 | 1683 | 0 | 1572.9
Beef Patty Regular 100g | 26.17 | 7 | [NAME] | 4 | 100 | 400 | 0 | 373.83
[NAME] | 251.21 | 7 | [NAME] | 36 | 220 | 4240 | 0 | 3962.62
Falafel Balls | 222.43 | 7 | XSD2 (6 pcs) | 34 | 100 | 3400 | 0 | 3177.57
San Miguel Light | 7.2 | 7 | BE5 | 1 | 110 | 110 | 0 | 102.8
[NAME] | 107.94 | 7 | CT13 | 15 | 110 | 1650 | 0 | 1542.06
Cappuccino Large | 93.55 | 7 | CT6 | 13 | 110 | 1430 | 0 | 1336.45
Moccaccino Large | 7.85 | 7 | CT10 | 1 | 120 | 120 | 0 | 112.15
[NAME] Large | 7.85 | 7 | CT8 | 1 | 120 | 120 | 0 | 112.15
[NAME] | 23.55 | 7 | ICE1 | 3 | 120 | 360 | 0 | 336.45
Yoghurt Passionfruit | 23.55 | 7 | ICE10 | 3 | 120 | 360 | 0 | 336.45
Chocolate Citrus Biscuit | 47.1 | 7 | ICE2 | 6 | 120 | 720 | 0 | 672.9
[NAME] | 7.85 | 7 | ICE3 | 1 | 120 | 120 | 0 | 112.15
Chocolate Gianduiotto | 15.7 | 7 | ICE4 | 2 | 120 | 240 | 0 | 224.3
Pistachio | 15.7 | 7 | ICE5 | 2 | 120 | 240 | 0 | 224.3
Milk Chocolate [NAME] | 31.4 | 7 | ICE6 | 4 | 120 | 480 | 0 | 448.6
French Vanilla | 31.4 | 7 | ICE7 | 4 | 120 | 480 | 0 | 448.6
[NAME] | 15.7 | 7 | ICE8 | 2 | 120 | 240 | 0 | 224.3
Tiramisu | 23.55 | 7 | ICE9 | 3 | 120 | 360 | 0 | 336.45
Carrot, Apple & Ginger Juice | 15.7 | 7 | JS13 | 2 | 120 | 240 | 0 | 224.3
French Toast | 39.25 | 7 | XBR4 | 5 | 120 | 600 | 0 | 560.75
[NAME] (4 pcs) | 219.81 | 7 | [NAME] | 28 | 120 | 3360 | 0 | 3140.19
Chicken & Bacon w/ [NAME] | 1554.39 | 7 | XSW1 | 295 | 989 | 53531 | 0 | 50028.98
[NAME] | 23.55 | 7 | XWR1 | 3 | 120 | 360 | 0 | 336.45
Falafel Wrap | 1091.21 | 7 | XWR3 | 174 | 345 | 24555 | 0 | 22948.6
[NAME] | 501.78 | 7 | [NAME] | 59 | 130 | 7670 | 0 | 7168.22
Falafel Salad | 323.18 | 7 | XSL2 | 38 | 130 | 4940 | 0 | 4616.82
Ham, Cheese & Tomato Panini | 1208.97 | 7 | XSW2 | 146 | 380 | 28140 | 0 | 26299.07
Lucky 13 Shawarma | 1382.99 | 7 | XWR1 | 221 | 535 | 38100 | 0 | 35607.47
Caesar Wrap | 932.24 | 7 | XWR2 | 128 | 405 | 22665 | 0 | 21182.25
Ham & Cheese Toastie | 703.27 | 7 | XBR2 | 109 | 640 | 21380 | 0 | 19981.31
American Breakfast Toastie | 507.01 | 7 | XBR3 | 48 | 410 | 10470 | 0 | 9785.05
Vegan [NAME]g | 11.12 | 7 | AM13 | 1 | 170 | 170 | 0 | 158.88
American Breakfast | 995.37 | 7 | XBR1 | 85 | 179 | 15215 | 0 | 14219.63
[NAME] 90g | 13.08 | 7 | AM21 | 1 | 200 | 200 | 0 | 186.92
[NAME] | 130.84 | 7 | XSW5 | 10 | 200 | 2000 | 0 | 1869.16
American Moby | 1779.44 | 7 | XBG1 | 151 | 1080 | 43720 | 0 | 40859.82
Lucky 13 Burger | 1653.83 | 7 | XBG2 | 130 | 540 | 36500 | 0 | 34112.14999999999
Vegan Mexican Burger | 565.23 | 7 | XBG3 | 46 | 540 | 12820 | 0 | 11981.31
Philly Cheese Steak | 1193.27 | 7 | XSW3 | 106 | 550 | 29510 | 0 | 27579.44
Mexican Cheese Steak | 586.17 | 7 | XSW4 | 63 | 550 | 17010 | 0 | 15897.19
American Breakfast Toastie | 32.71 | 7 | XBK2 | 2 | 250 | 500 | 0 | 467.29
Hoegaarden Original 33cl | 17.66 | 7 | BE6 | 1 | 270 | 270 | 0 | 252.34
Hoegaarden Rose 33cl | 17.66 | 7 | BE8 | 1 | 270 | 270 | 0 | 252.34
[NAME] | 20.93 | 7 | BE11 | 1 | 320 | 320 | 0 | 299.07