L16:L18=COUNT(0/MMULT(N(M16=L$5:N$9),{1;1;1}))
F13:F25{=IFERROR(OFFSET(M$15,SMALL(IF(L$16:L$18>=COLUMN(A:Z),{1;2;3}),ROW(A1)),),"")
G13:H25{=IF($F13="","",OFFSET(G$4,SMALL(IF(MMULT(N($L$5:$N$9=$F13),{1;1;1}),ROW($1:$5)),COUNTIF($F$13:$F13,$F13)),))
I13:I25{=IF($F13="","",INDEX(MMULT(N(L$5:N$9=F13),{1;1;1}),SMALL(IF(MMULT(N(L$5:N$9=F13),{1;1;1}),ROW($1:$5)),COUNTIF(F$13:F13,F13))))
J13:J25=IF($F13="","",SUMIFS(J$5:J$9,G$5:G$9,G13,H$5:H$9,H13)*I13)
L16:L18=SUMIF(F:F,M16,J:J)
留言
張貼留言