I2{=INDEX(D:D,SMALL(IF((MONTH(C$2:C$16)&D$2:D$16<>MONTH(C$3:C$17)&D$3:D$17)*(MONTH(C$2:C$16)-LEFTB(G$2,2)=0),ROW($2:$16),99),ROW(A1)))&""
J2{=IF(I2="","",SUM(OFFSET(E$1,MAX(SMALL(IF((MONTH(C$2:C$16)&D$2:D$16<>MONTH(C$3:C$17)&D$3:D$17)*(MONTH(C$2:C$16)-LEFTB(G$2,2)=0),ROW($2:$16),99),ROW(A1))-1),,1-MATCH(1=1,T(OFFSET(D$1,MAX(SMALL(IF((MONTH(C$2:C$16)&D$2:D$16<>MONTH(C$3:C$17)&D$3:D$17)*(MONTH(C$2:C$16)-LEFTB(G$2,2)=0),ROW($2:$16),99),ROW(A1))-1),,-ROW($1:$9)))<>I2,))))
留言
張貼留言