本帖最后由 willin2000 于 2015-10-19 14:54 编辑
我的答案是:
143字符
03版本:数组公式,写在F1,右拉下拉
- =INDEX($A:$A,SMALL(9*($B$2:$B4-COUNTIF(F2:F$8,$A$2:$A4)-COUNTIF(G:Q,$A$2:$A4)<COLUMN($A:DA))+ROW($2:4),INT(RAND()*(ROW()+7*COLUMN()-42))+1))&""
复制代码
07版本:区域数组公式
=INDEX(A:A,LOOKUP(MOD(SMALL(RANDBETWEEN(0^ROW(1:77),99)/1%+ROW(1:77),ROW()+7*COLUMN()-42),100)-1,MMULT(N(ROW(1:4)>COLUMN(A:C)),B2:B4),ROW(2:5)))&""
COLUMN(A:C)可以化为{1,2,3}
143字符
- =INDEX(A:A,LOOKUP(MOD(SMALL(RANDBETWEEN(0^ROW(1:77),99)/1%+ROW(1:77),ROW()+7*COLUMN()-42),100)-1,MMULT(N(ROW(1:4)>COLUMN(A:C)),B2:B4),ROW(2:5)))&""
复制代码
75字符,附加题的公式
- =MMULT(IFERROR(SMALL(RANDBETWEEN({0;0},15),{0,1;1,2;2,3}),{0,15}),{-1;1})+5
复制代码
85字符,通用易改就这个
- =MMULT(IFERROR(SMALL(RANDBETWEEN(0^ROW(1:2),15),ROW(1:3)-{1,0}),{0,15}),{-1;1})+5
复制代码 |