I3 下拉{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF((TEXT(A$3:A$36,"YYYM")=(D$3&E$3))*(COUNTIF(I$2:I2,B$3:B$36)=0),SUMIFS(C$3:C$36,A$3:A$36,">="&D$3&-E$3,A$3:A$36,"<="&EOMONTH(D$3&-E$3,0),B$3:B$36,B$3:B$36)/1%+ROW($3:$36)),1),2)),"")
J3 下拉=IF(I3="","",SUMIFS(C$3:C$36,A$3:A$36,">="&D$3&-E$3,A$3:A$36,"<="&EOMONTH(D$3&-E$3,0),B$3:B$36,I3))
留言
張貼留言