p

need information on an excel formula to answer question 6

VVICII 6 Which product pairs (triplets, quadruplets) were most frequently purchased together? (bonus) B 0 0 5 Purchase Price 2.5 2.5 B 9 9 2 3 3 ID = Purchased Item 1 Bread 1 Bread 1 Bread 2 Coffee Coffee 2 Coffee 2 Coffee Cheese 3 deuse 3 Vegetables 4 Candy 5 Chips 5 Chips 5 Bread 6 Bread 7 Milk & Bread Water 9 Juice 9 Juice Juice 9 cookies 9 Meat 9 Energy Drink 9 Energy Drink 3 3.4 3 3 25 25 25 1 1.5 UN LIT 2.3 7.2 IN 3 10 Nik 10 Yogurt 20 10 Vegetables 2 10 Candy 10 Vegetables 10 Water 10 Water 10 Water 11 Energy Drink 11 Meat 11 Vegetables 11 Cereal 11 Bread 11 Bread 11 Juice 7.2 2.8 5 25 25 35 Product Ir Product Name I Bread 2 Butter 3 Candy 4 Cereal 5 Cheese 6 Chips 7 Calle 8 Cookies Desserts 12 Energy Drink 16 Juice 17 Meat 18 Milk 19 Muffin 20 Non-Alcoholic Drinks 21 Nuts 22 Oatmeal 23 Oil 25 Popcorn 21 Soup 22 Spices 33 Sugar 15 Vegetables 27 Vanu