Spreadsheet: 752649d1634881094-help-to-create-an-order-list-based-on-products-by-cheapest-supplier-price-comparison-test-1-
Sheet: DATA INPUT

Product | Department | Supplier | Price | Quantity | Unit Price | Date | % change | Order Code | Notes |  | Departments
10" Greaseproof bag | TA Packaging | ABPAC | 16.82 | 1000 |  |  |  | 1234 | Test |  | TA Packaging
10" Greaseproof bag | TA Packaging | BAKO | 16 | 1000 |  |  |  |  |  |  | [NAME]
10" Greaseproof bag | TA Packaging | Catering 24 | 19.02 | 1000 |  |  |  |  |  |  | [NAME]
12oz compostable d/w cup | TA Packaging | Catering 24 | 45.54 | 500 |  |  |  |  |  |  | Cleaning Supplies
12oz compostable d/w cup | TA Packaging | Next Day Coffee | 43.19 | 500
12oz compostable d/w cup | TA Packaging | [NAME] | 53.1 | 500
12oz compostable lid | TA Packaging | Catering 24 | 53.99 | 1000
12oz compostable lid | TA Packaging | Next Day Coffee | 29.75 | 500
12oz compostable lid | TA Packaging | [NAME] | 54.84 | 1000
7" Greaseproof bag | TA Packaging | ABPAC | 10.28 | 1000
7" Greaseproof bag | TA Packaging | BAKO | 6.88 | 1000
7" Greaseproof bag | TA Packaging | Catering 24 | 9.77 | 1000
8oz compostable d/w cup | TA Packaging | Catering 24 | 38.34 | 500
8oz compostable d/w cup | TA Packaging | Next Day Coffee | 38.39 | 500
8oz compostable d/w cup | TA Packaging | [NAME] | 43.56 | 500
8oz compostable lid | TA Packaging | Catering 24 | 59.34 | 1000
8oz compostable lid | TA Packaging | Next Day Coffee | 25.19 | 500
8oz compostable lid | TA Packaging | [NAME] | 45.35 | 1000
Nesting Tray | TA Packaging | ABPAC | 32.74 | 500 |  |  |  |  | Too Expensive
Nesting Tray | TA Packaging | Bonds Packaging | 21.12 | 220
No. 1 [NAME] | TA Packaging | Catering 24 | 56.99 | 450
No. 1 [NAME] | TA Packaging | Enviropack | 59.94 | 450
No. 1 [NAME] | TA Packaging | Enviropack 4+ | 56.39 | 450
No. 3 [NAME] | TA Packaging | Catering 24 | 42.24 | 180
No. 3 [NAME] | TA Packaging | Enviropack | 44.34 | 180
No. 3 [NAME] | TA Packaging | Enviropack 4+ | 41.99 | 180
Perforated Film Front [NAME] bag | TA Packaging | Enviropack | 36.54 | 1000
Perforated Film Front [NAME] bag | TA Packaging | Enviropack 5+ | 33.59 | 1000
Perforated Film Front [NAME] bag | TA Packaging | Next Day Coffee | 39.59 | 1000
SOS Carrier Bag | TA Packaging | Catering 24 | 21.59 | 250
SOS Carrier Bag | TA Packaging | Enviropack | 21.59 | 250
SOS Carrier Bag | TA Packaging | Enviropack 5+ | 19.79 | 250
8oz compostable d/w  cup | TA Packaging | Cups Direct | 41.94 | 500
12oz compostable d/w cup | [NAME] | Cups Direct | 51.54 | 500
Coke | [NAME] | BOOKER | 10.99 | 24
Diet Coke | [NAME] | BOOKER | 8.99 | 24
Volvic | [NAME] | BOOKER | 3.89 | 24
[NAME] | [NAME] | BOOKER | 9.99 | 24
San Pellegrino Orange | [NAME] | BOOKER | 9.99 | 24
San Pellegrino Sparkling | [NAME] | BOOKER | 4.49 | 24
Kombucha Original | [NAME] | SUMA | 12.75 | 12
[NAME] | [NAME] | SUMA | 12.75 | 12
Cawston Cloudy Apple Juice | [NAME] | SUMA | 16.97 | 24
Cawston Cloudy Apple Juice & Rhubarb | [NAME] | SUMA | 16.97 | 24
Cawston Cloudy Apple & Elderflower | [NAME] | SUMA | 16.97 | 24
Penningtons Fine Lakeland Tea 250g | [NAME] | Penningtons | 5.35 | 250
Chit Chat Coffee | [NAME] | Mr Duffin | 15.8 | 66
Chit Chat Retail Coffee | [NAME] | Mr Duffin | 4.3 | 1
Chit Chat Decaf Coffee | [NAME] | Mr Duffin | 17.5 | 66
Pimms | [NAME] | Booker | 10.99 | 1
Baileys | [NAME] | Booker | 10.99 | 1
Coke BIB | [NAME] | Booker | 61.99 | 1 |  |  |  | 5555 | 7777
Diet Coke BIB | [NAME] | Booker | 51.99 | 1
Ginger Beer | [NAME] | Booker | 10.99 | 12
Old Mout Berries & Cherries | [NAME] | Booker | 16.19 | 12
Old Mout Kiwi & Lime | [NAME] | Booker | 16.19 | 12
Peroni | [NAME] | Booker | 20.99 | 24
Shipyard American IPA | [NAME] | Booker | 10.49 | 8
Wyldwood Organic Cider | [NAME] | Booker | 9.99 | 10
Scweppes BIB | [NAME] | Booker | 58.99 | 1
Strathmore Still Mineral Water | [NAME] | Booker | 6.85 | 24
Strathmore Sparkling Mineral Water | [NAME] | Booker | 6.39 | 24
Prosecco Spumante | [NAME] | Booker | 24.99 | 12
Cawston Press Apple Juice | [NAME] | Suma | 11.7 | 6
Cawston Press Apple & Elderflower | [NAME] | Suma | 11.7 | 6
[NAME] | [NAME] | Booker | 18.99 | 1040
[NAME] | [NAME] | JMP | 21.88 | 1040
Orange Syrup | [NAME] | Next Day Coffee | 6.69 | 1
[NAME] | [NAME] | Next Day Coffee | 6.69 | 1
[NAME] | [NAME] | Next Day Coffee | 6.69 | 1
[NAME] | [NAME] | Next Day Coffee | 6.69 | 1
[NAME] | [NAME] | Next Day Coffee | 6.69 | 1
[NAME] | [NAME] | Next Day Coffee | 6.69 | 1
Fine Lakeland Tea (1kg) | [NAME] | Penningtons | 18.5 | 1000
Decaf Tea | [NAME] | Penningtons | 3.45 | 40
[NAME] | [NAME] | Penningtons | 4.15
Kendal Mint Cake Tea | [NAME] | Penningtons | 4.15
Apple & Lemon Tea | [NAME] | Penningtons | 4.15
Passionfriut & Orange | [NAME] | Penningtons | 4.15
[NAME] | [NAME] | Penningtons | 3.75 | 40
Sugar Sticks White | [NAME] | Penningtons | 10.6 | 1000
Sugar Sticks Brown | [NAME] | Penningtons | 11.45 | 1000
[NAME] | [NAME] | Penningtons | 8.7 | 1
Twinings Peppermint Tea | [NAME] | JMP | 2.02 | 20
Twinings Lemon & Ginger Tea | [NAME] | JMP | 2.02 | 20
Twinings Green Tea | [NAME] | JMP | 2.02 | 20
[NAME] | [NAME] | Next Day Coffee | 27.99 | 1040
Blue Centrefeed Roll | Cleaning Supplies | [NAME] | 10.13 | 6
Dishwash Detergent 20l | Cleaning Supplies | [NAME] |  | 1
Rinse Aid 20l | Cleaning Supplies | [NAME] |  | 1
Alu Traywash MD6 | Cleaning Supplies | [NAME] | 28.73 | 1
[NAME] Detergent 5l | Cleaning Supplies | [NAME] | 3.53 | 1
[NAME] Aid 5l | Cleaning Supplies | [NAME] |  | 1
Jangro Supreme Washing Up Liquid 5l | Cleaning Supplies | [NAME] |  | 1
K5 [NAME] | Cleaning Supplies | [NAME] | 7.21 | 1
K4 Kitchen Sanitiser | Cleaning Supplies | [NAME] |  | 1
W1 Washroom Cleaner | Cleaning Supplies | [NAME] |  | 1
Perfumed Toilet Cleaner | Cleaning Supplies | [NAME] |  | 1
[NAME] 5l | Cleaning Supplies | [NAME] | 5.41 | 1
Jangro Glass & Mirror Cleaner | Cleaning Supplies | [NAME] |  | 1
[NAME] | Cleaning Supplies | [NAME] |  | 1
Citrus Grove Airfreshner | Cleaning Supplies | [NAME] |  | 1
Poppies [NAME] (Box) | Cleaning Supplies | [NAME] | 26.93 | 2000
Jangro Toilet Rolls | Cleaning Supplies | [NAME] | 23.46 | 36
Hand Towels Zig Zag | Cleaning Supplies | [NAME] | 21.8 | 20