算級距分 (10123)


G2=MMULT(INT(COUNTIF(OFFSET(A$2:A$21,,COLUMN(A:E)),"<"&B2:F21)/(20/5))+1,{1;1;1;1;1})


I2:M21=INT((RANK(B2,B:B,1)-1)/(20/5))+1


N2=SUM(I2:M2)


留言