SOLVED

Extract data from table to write at other tables

%3CLINGO-SUB%20id%3D%22lingo-sub-1516853%22%20slang%3D%22en-US%22%3EExtract%20data%20from%20table%20to%20write%20at%20other%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516853%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%3C%2FP%3E%3CP%3EAssume%20i%20have%20a%20table%20that%20has%20information%20of%20customer%20and%20product%20they%20bought.%20is%20there%20any%20function(s)%20or%20function(s)%20combination%20that%20can%20help%20me%20to%20automatically%20write%20down%20the%20names%20of%20customer%20based%20on%20product%3F%20(can%20excel%20help%20me%20to%20create%20new%20tables%20based%20on%20products%3F)%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1516853%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-1516876%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20data%20from%20table%20to%20write%20at%20other%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516876%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F658761%22%20target%3D%22_blank%22%3E%40misteree%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20attached%20sample%20file%20with%20you%20desired%20result%20manually%20entered%20to%20advise%20you%20the%20correct%20solution%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

hi,

Assume i have a table that has information of customer and product they bought. is there any function(s) or function(s) combination that can help me to automatically write down the names of customer based on product? (can excel help me to create new tables based on products?)

Thank you

 

here i attach file for example, i try to automatically make new tables of student based on each subject.

4 Replies
Highlighted

Hi @misteree

 

Please attached sample file with you desired result manually entered to advise you the correct solution 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

 

Highlighted

thank you @Faraz Shaikh i attached the example and i made the table manually

 

Highlighted
Best Response confirmed by misteree (New Contributor)
Solution

Hi @misteree,

 

Pls find attached solution for your query. If you have Microsoft365 (Office365) then you can take the advantage for these new dynamic arrays function or you need use the classic array 

 

I have attached both the solution for you.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

 

 

 

Highlighted

thank you @Faraz Shaikh, i try it already and it works perfectly.