A13:J22=RAND()
A1:J10=CHOOSE(LOOKUP(RANK(A13,$A$13:$J$22),{1,21,71},{1,2,3}),1,RANDBETWEEN(2,3),4)
驗證 M2:M5=COUNTIF(A:J,L2)
以生成20个為例 P1:P20 区域函数{=LOOKUP(RIGHT(SMALL(RANDBETWEEN(ROW(1:20)^0,99)/1%%+ROW(1:20),ROW(1:20)),4)*1,SMALL(IF({1;0},{1,5},IF({1,0},RANDBETWEEN(51,149)/10,15)),{1,2,3,4}),{1,2,3,4})
留言
張貼留言