Excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2801811%22%20slang%3D%22en-US%22%3EExcel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2801811%22%20slang%3D%22en-US%22%3EHello!%20Please%20help%20me!%3CBR%20%2F%3EI%20have%20a%20list%20with%20products%20in%20column%20A%20(A1%2CA2%2CA3%2CA4%2CA5%2CA6)%20and%20in%20column%20B%2C%20C%2C%20D%20i%20have%20people%20who%20consume%20that%20products.%20I%20want%20to%20make%20a%20table%2C%20for%20each%20people%2C%20with%20his%20consumption.%3CBR%20%2F%3EFor%20example%2C%20people%20from%20column%20B%20consum%20only%20productc%20from%20A1%2C%20A3%20and%20A6.%20People%20from%20column%20C%20consum%20only%20products%20from%20A2%2C%20A5.%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20can%20i%20make%20a%20table%20for%20eact%20person%20with%20his%20consumption%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThx%20a%20lot%20!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2801811%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2802226%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2802226%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1172011%22%20target%3D%22_blank%22%3E%40Rraducuu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20attach%20a%20small%20sample%20workbook%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
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?

Thx a lot !
4 Replies

@Rraducuu 

Please attach a small sample workbook

@Rraducuu 

Perhaps FILTER() will work.

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).

Thx a lot & in advance!

@Rraducuu 

 

Please attach a sample workbook with some dummy data.