C2:C11 輔助列公式:
=B2&IFERROR(","&VLOOKUP(A2,A3:B$12,2,),)
E4 陣列公式:
=--TRIM(
MID(
SUBSTITUTE(VLOOKUP(D4,A:C,3,),",",REPT(" ",100)),
100*ROW(INDIRECT("1:"&LEN(VLOOKUP(D4,A:C,3,))-LEN(SUBSTITUTE(VLOOKUP(D4,A:C,3,),",",))+1))-99,
100
))
※陣列公式,請記得按Ctrl+Shift+Enter
※如果有解決您的問題,再請將帖子設為[已解決]
祝順心,南無阿彌陀佛!
|