INDIRECT(CHOOSE(RANDBETWEEN(1,3),"A","B","C")&RANDBETWEEN(1,10))
这是1个的，
INDIRECT(CHOOSE(RANDBETWEEN(1,3),"A","B","C")&RANDBETWEEN(1,10))&INDIRECT(CHOOSE(RANDBETWEEN(1,3),"A","B","C")&RANDBETWEEN(1,10))
这是2个的
其实都一样，只不过用&连接起来了
1,3 是指列，你有3列就是3，如果4列，要在),"A","B","C"后面加D；10是你的行，有7行，这里就是7.
哦了，用公式即可，不用宏了。
=IF(RAND()>0.5,A1,"") & IF(RAND()>0.5,A2,"") & IF(RAND()>0.5,A3,"") ....
照这样把全部单元格写上 就类似你要的结果.
要更准确的 就要用宏来实现,加扣扣 有空时为你做一下
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024