K2:K8{=IFERROR(INDIRECT(TEXT(RIGHT(MIN(IF((COUNTIF(K$1:K1,A$2:F$6)=0)*COUNTIF(A$2:F$6,"<="&A$2:F$6)*ISERR(-A$2:F$6),COUNTIF(A$2:F$6,"<="&A$2:F$6)/1%%+ROW($2:$6)/1%+COLUMN(A:F))),4),"!R0C00"),),"")
L2:O8{=IFERROR(AVERAGE(IF(IF({1,0},SUM(($B$1:$D$1=L$1)*($A$2:$A$6=$K2)*$B$2:$D$6),SUM(($G$1:$I$1=L$1)*($F$2:$F$6=$K2)*$G$2:$I$6)),IF({1,0},SUM(($B$1:$D$1=L$1)*($A$2:$A$6=$K2)*$B$2:$D$6),SUM(($G$1:$I$1=L$1)*($F$2:$F$6=$K2)*$G$2:$I$6)))),"")
留言
張貼留言