F2:F5{=TEXT(INDEX(B:B,RIGHT(LARGE(IF((MATCH(WEEKDAY(B$2:B$17,2),WEEKDAY(B$2:B$17,2),)=ROW($1:$16))*ISNUMBER(FIND(WEEKDAY(B$2:B$17,2),1234)),MMULT(N(TRANSPOSE(WEEKDAY(B$2:B$17,2))=WEEKDAY(B$2:B$17,2)),D$2:D$17)/1%+ROW($2:$17)),ROW(A1)),2)),"AAA")
G2=SUMIF(C:C,F2,D:D)
J2:J17=WEEKDAY(B2,2)
K2{=TEXT(INDEX(B:B,RIGHT(LARGE(IF((MATCH(J$2:J$17,J:J,)=ROW($2:$17))*(J$2:J$17<5),SUMIF(J:J,J$2:J$17,D:D)/1%+ROW($2:$17)),ROW(A1)),2)),"AAA")
留言
張貼留言