合併數據 取日期後面值 (8884)

E4{=TRIM(RIGHT(SUBSTITUTE(VLOOKUP(TEXT(D4,"YYY-M-D")&"*",TRIM(MID(SUBSTITUTE(B$2,";",REPT(" ",99)),ROW($1:$9)*99-98,99)),1,),",",REPT(" ",9)),9))

取數字最大 999 F4=LOOKUP(9^9,MID(B$2,FIND(",",B$2,FIND(TEXT(D4,"YYY-m-d"),B$2))+1,ROW($1:$9))/1)

取數字最大 999 G4=LOOKUP(9^9,MID(B$2,FIND(",",B$2,FIND(TEXT(D4,"YYY-m-d"),B$2))+1,ROW(1:9))/1)

日期重複可加總 H4{=SUM(IFERROR(--SUBSTITUTE(MID(SUBSTITUTE(B$2,";",REPT(" ",99)),ROW($1:$9)*99-98,99),TEXT(D4,"YYY-m-d,"),),))