C2:C10{=IFERROR(TRIM(LEFT(SUBSTITUTE(INDEX(LOOKUP(ROW(A$2:A$10),ROW(A$2:A$10)/ISERR(FIND("区",A$2:A$10)),A$2:A$10),SMALL(IF(1-ISERR(FIND("区",A$2:A$10)),ROW($1:$9)),ROW(A1)))," ",REPT(" ",9)),9)),"")
D2:D10=IF(C2="","",RIGHT(VLOOKUP(C2&"*",A:A,1,),11))
E2:J10{=TRIM(MID(SUBSTITUTE(OFFSET($A$1,MATCH(1,FIND($C2,$A$2:$A$10))+COUNTIF($C$2:$C2,$C2),)," ",REPT(" ",99)),COLUMN(A1)*99-98,99))
留言
張貼留言