生活 返回
天气预报 > 生活 > excel填充无规律数字
excel填充无规律数字
更新时间： 2021-03-24 00:10:04  

1、输入以下公式，然后向下填充公式，=RANDBETWEEN(725,737)，生成725－737中的随机整数。

2、输入=INT(725+RAND()*12)。

3、在A1单元格输入公式=rand()，往下拉。

关键词： excel 填充 无规律 数字

excel填充无规律数字相关经验

天气预报

最新推荐

页面:/news/view-773881/ | 耗时:0.8485 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=773881 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=773881 LIMIT 0,1
select * from tbl_Articles_sphinx where id=773881 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1155105,440471,1475821,3228929,849027,1219296,516526,828715,4027379,1927528,3098509,3273783,3884178,2657046,977923,615781,3399276,1441530,1027782,3464525,1078928,3350290,2818827,3430568,2588865,491337,511588,697872,1218588,2835715) ORDER BY field (ArticleID,1155105,440471,1475821,3228929,849027,1219296,516526,828715,4027379,1927528,3098509,3273783,3884178,2657046,977923,615781,3399276,1441530,1027782,3464525,1078928,3350290,2818827,3430568,2588865,491337,511588,697872,1218588,2835715)