Excel 编写随机数据

随机生成手机号

=1&CHOOSE(RANDBETWEEN(1,4),"3","5","7","8")&RANDBETWEEN(100000000,999999999)

随机生成日期

=TEXT(RAND()*("1981-1-1"-"2011-5-1")+"2011-5-1","yyyy-m-d")

生成 在1981-1-1 到 2011-5-1 之间的随机日期

随机生成学历

CHOOSE(RANDBETWEEN(1,6),"高中","中专","大专","本科","硕士","博士")

随机生成姓名

首先准备姓氏，根据百家姓生成姓氏列表，将姓氏列表放置在sheet表单的某一列，如 U列

其次准备名字，将所需要的名字放置在sheet表单的某个区域，如在H1：S26区域，

最后，在需要的列

=INDIRECT("U"&RANDBETWEEN(1,100))&INDEX($H$1:$S$26,RANDBETWEEN(1,26),RANDBETWEEN(1,12))

随机生成年龄

=RANDBETWEEN(21,59)

生成 最小21，最大59的年龄

随机生成部门

=CHOOSE(RANDBETWEEN(1,6),"人力资源部","财务部","销售部","总裁办","法务部","生产经营部")

部门根据各自需要可随意定义，如定义10个部门，则 randbetween(1,10)

原文链接：https://blog.csdn.net/mystonelxj/article/details/79566068

(资源库 www.zyku.net)