B8:B15{=INDEX(B:B,RIGHT(SMALL(IF(1-ISERR(FIND(COLUMN(A:I)&".",C$2:C$3)),{2;3},99),ROW(A1)),2))&""
C8:C15=IF(B8="","",LEFT(VLOOKUP(B8,B:C,2,),FIND("：",VLOOKUP(B8,B:C,2,))-1))
D8:D15=TRIM(MID(SUBSTITUTE(SUBSTITUTE(VLOOKUP(B8,B:C,2,),C8&"：",),"。",REPT(" ",99)),COUNTIF(B$8:B8,B8)*99-98,99))
留言
張貼留言