C5:C8{=IFERROR(MID(C$2,SMALL(IF(MID(C$2,ROW($1:$499),2)="【0",ROW($1:$499)),ROW(A1)),MATCH(1=1,MID(C$2,SMALL(IF(MID(C$2,ROW($1:$499),2)="【0",ROW($1:$499)),ROW(A1))+ROW($1:$99)-1,1)=")",)),"")
D5:D8{=IF(C5="","",-LOOKUP(9,-MID(MID(C$2,SMALL(IF(MID(C$2,ROW($1:$499),2)="【0",ROW($1:$499)),ROW(A1)),99),FIND("元",MID(C$2,SMALL(IF(MID(C$2,ROW($1:$499),2)="【0",ROW($1:$499)),ROW(A1)),99))-ROW($1:$9),ROW($1:$9))))
留言
張貼留言