Hello! Please help me! I have a list with products in column A (A1,A2,A3,A4,A5,A6) and in column B, C, D i have people who consume that products. I want to make a table, for each people, with his consumption. For example, people from column B consum only productc from A1, A3 and A6. People from column C consum only products from A2, A5.
How can i make a table for eact person with his consumption?
Please seee attached photos. First photo is the main table with all products and all people. (Consumption worksheet) Second photo is the individual table. (For ex. Charteres Consumption worksheet) So, i need from main table to import only products which was consumed pe individuals, and not all. For exemple "Charteres" consum only items from A6 & A15. Be aware that i did not find =filter(). I am usint microsoft office 2013 (or 2016).