Jul 12 2020 02:37 AM - edited Jul 12 2020 04:47 AM
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.
Jul 12 2020 02:58 AM
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
Jul 12 2020 04:50 AM
thank you @Faraz Shaikh i attached the example and i made the table manually
Jul 12 2020 05:30 AM - edited Jul 12 2020 05:34 AM
SolutionHi @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
Jul 12 2020 04:19 PM
thank you @Faraz Shaikh, i try it already and it works perfectly.
Jul 12 2020 05:30 AM - edited Jul 12 2020 05:34 AM
SolutionHi @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