K2{=SUM(N(MMULT(INT(RIGHT(IFERROR(SMALL(-ROW($1:$15)*10^8-C$2:J$16/1%-COLUMN(C:J),IF(TRANSPOSE(M$2:M$9),ROW($1:$15)*8-8+TRANSPOSE(M$2:M$9))),),4)%),ROW(1:8)^0)>SUM(INT(IFERROR(LARGE(C2:J2/1%+COLUMN(C:J),M$2:M$9)%,)))))+1
O2{=SUM(INT(IFERROR(LARGE(C2:J2/1%+COLUMN(C:J),M$2:M$9)%,)))
P2=RANK(O2,O:O)
C2:J16 格式化=COUNTIF($M:$M,RANK(C2,$C2:$J2))
留言
張貼留言