B6 =IF(COLUMN(A1)>SUM(--(FREQUENCY($A$1:$K$1,ROW($1:$8))=ROW()-6)),"",SMALL(IF(FREQUENCY($A$1:$K$1,ROW($1:$8))=ROW()-6,ROW($1:$9)),COLUMN(A1))) B12 =1/MOD(LARGE(FREQUENCY($A$1:$K$1,ROW($1:$8))*10+1/ROW($1:$9),COLUMN(A1)),10) B13 =INT(LARGE(FREQUENCY($A$1:$K$1,ROW($1:$8))*10+ROW($1:$9),COLUMN(A2))/10)
ihmA8LIT.rar
(6.11 KB, 下载次数: 15)
|