D2{=IFERROR(-LOOKUP(1,-LEFT(INDEX(B:B,SMALL(IF(LEN(B$2:B$5)-LEN(SUBSTITUTE(B$2:B$5,"元",))>={1,2,3},ROW($2:$5)),ROW(A1))),{9,10,11})),"")
E2=IF(D2="","",TRIM(MID(SUBSTITUTE(SUBSTITUTE(LOOKUP(1,0/FIND(TEXT(D2,"YYY年M月D日"),B$2:B$5),B$2:B$5),"个","对"),"对",REPT(" ",99)),COUNTIF(D$2:D2,D2)*198-99,99)))
F2=IF(D2="","",TRIM(MID(SUBSTITUTE(SUBSTITUTE(LOOKUP(1,0/FIND(TEXT(D2,"YYY年M月D日"),B$2:B$5),B$2:B$5),"币","元"),"元",REPT(" ",99)),COUNTIF(D$2:D2,D2)*198-99,99)))
留言
張貼留言