H2:I10{=INDEX(A:A,SMALL(IF(LEN($C$2:$C$5)-LEN(SUBSTITUTE($C$2:$C$5,CHAR(10),))+1>=COLUMN($A:$Z),ROW($2:$5),99),ROW(A1)))&""
J2:L10=IF($H2="","",TRIM(MID(SUBSTITUTE(VLOOKUP($H2,$A:$F,COLUMN(C1),),CHAR(10),REPT(" ",99)),COUNTIF($H$2:$H2,$H2)*99-98,99)))
留言
張貼留言