excel表格怎么0102

1.你好

=SUMPRODUCT(({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18}=RANDBETWEEN(1,18))*({1,2,3,26,28,29,30,7,39,18,20,10,38,11,12,13,128,51}))

或

=CHOOSE(RANDBETWEEN(1,18),1,2,3,26,28,29,30,7,39,18,20,10,38,11,12,13,128,51)

或

=SUMPRODUCT((COLUMN($A$1:$R$1)=RANDBETWEEN(1,18))*({1,2,3,26,28,29,30,7,39,18,20,10,38,11,12,13,128,51}))

或

=SUMPRODUCT((ROW($A$1:$A$18)=RANDBETWEEN(1,18))*({1;2;3;26;28;29;30;7;39;18;20;10;38;11;12;13;128;51}))

如果RANDBETWEEN(1,18)函数用不了，请改成使用RAND（)的函数，如下：

=SUMPRODUCT(({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18}=INT(RAND()*17)+1)*({1,2,3,26,28,29,30,7,39,18,20,10,38,11,12,13,128,51}))

或

=CHOOSE(INT(RAND()*17)+1,1,2,3,26,28,29,30,7,39,18,20,10,38,11,12,13,128,51)

或

=SUMPRODUCT((COLUMN($A$1:$R$1)=INT(RAND()*17)+1)*({1,2,3,26,28,29,30,7,39,18,20,10,38,11,12,13,128,51}))

或

=SUMPRODUCT((ROW($A$1:$A$18)=INT(RAND()*17)+1)*({1;2;3;26;28;29;30;7;39;18;20;10;38;11;12;13;128;51}))