O8:P14{=COUNT(0/(MATCH($N8&$C$8:$C$24&O$7,TEXT($B$8:$B$24,"ddd")&$C$8:$C$24&$D$8:$D$24,)=ROW($1:$19)))
L8:L24{=MAX((B$8:B$24=B8)*(D$8:D$24=D8)*(F$8:F$24=F8)*I$8:I$24)
O19:P25{=SUM(IFERROR((MATCH($N19&O$18&$F$8:$F$24,TEXT($B$8:$B$24,"ddd")&$D$8:$D$24&$F$8:$F$24,)=ROW($1:$19))*$L$8:$L$24,))
S19:T25{=SUM((IFERROR(MATCH($R19&S$18&$F$8:$F$24,TEXT($B$8:$B$24,"DDD")&$D$8:$D$24&$F$8:$F$24,),)=ROW($1:$17))*RIGHT(SMALL(($B$8:$B$24&$D$8:$D$24&$F$8:$F$24=TRANSPOSE($B$8:$B$24&$D$8:$D$24&$F$8:$F$24))*TRANSPOSE($I$8:$I$24)+ROW($8:$24)/1%%,ROW($1:$17)*17),4))
留言
張貼留言