【按F9键】自动生成名字

  • 格式:xls
  • 大小:99.50 KB
  • 文档页数:2

王李张刘陈伟刚勇毅俊政谦俞倩倪倰偀偲妆佳亿仪寒 纤随机生成男女孩姓名
杨黄吴赵周峰强军平保之轮宜妶好妃姗姝姹姿婵宛玉炎徐孙马朱胡东文辉力明宏言姜姣嫦嫱姬娇娟嫣婕娜姳舒林郭何高罗永健世广志斌梁妍妙娆娉娥媚媱嫔婷玟蕾 炫郑梁谢宋唐义兴良海山克翔环珆珊珠玲珴瑛琼瑶瑾瑞 依许邓冯韩曹仁波宁贵福泽晨珍琦玫琪琳环琬瑗琰薇珂 烟曾彭萧蔡潘生龙元全国建家芬芳芯花茜荭荷莲莉莹菊 融田董袁于余胜学祥才发德行芝萍燕苹荣蕊芮蓝莎菀姯然随机生成女孩(2个字)姓名叶蒋杜苏魏武新利清飞雄琛菁苑芸芊茗荔菲蓉英蓓蕾 文程吕丁沈任彬富顺信子腾楠薰颖芃蔓莓曼淼滟滢淑姞 平姚卢傅钟姜杰涛昌成康亨奇洁清澜波淞渺漩漪涟湾汇 爽崔谭廖范汪星光天达安翰朗冰冷冽霜雪霞霖香馡馥秋 烁随机生成女孩\(3个字)姓名陆金石戴贾岩中茂进林若鸣秀露飘育滢馥筠柔竹凝雨伊韦夏邱方侯有坚和彪博栋维晓欢枫巧美静惠翠雅红春 煜邹熊孟秦白诚先敬震振旭鹏岚嵘兰羽素云华丽俪叆呤 亚江阎薛尹段壮会思群豪辰士咛彩彤彨怜晴月明晶昭婉炅雷黎史龙陶心邦承乐绍致树星卿毓可璧青灵彩慧盈眉 园贺顾毛郝龚功松善厚庆时泰艳婧凤风勤叶雁钰嘉锦娴 冉邵万钱严赖磊民友裕河钧冠黛怡情林梦越悦希宁欣容 心覃洪武莫孔哲江超浩亮榕风丹彤颜影韵音银纯纹思丝 屏固伯朋启弘以炎=INDEX(Sheet1!$A$2:$E$21,INT(RAND()*20!$O$2:$Z$21,INT(RAND()*20+1),INT(RAND()*12+1))&INDEINT(RAND()*20+1),INT(RAND()*12+1))百家姓男孩名常用字女孩名常用字=IF(INT(RAND()*2+1)=1,INDEX(Sheet1!$A$
()*5+1))&INDEX(Sheet1!$O$2:$Z$21,INT(RAND()*20+1),I
EX(Sheet1!$A$2:$E$21,INT(RAND()*20+1),INT(RAND()*5+
2:$Z$21,INT(RAND()*20+1),INT(RAND()*12+1))&INDEX(Sh
RAND()*20+1),INT(RAND()*12+1)))

=INDEX(Sheet1!$A$2:$E$21,INT(RAND()*20
!$O$2:$Z$21,INT(RAND()*20+1),INT(RAND()*12+1))
()*20+1),INT(RAND()*5+1))&INDEX(Sheet1
1),INT(RAND()*12+1))&INDEX(Sheet1!$O$2:$Z$21,
)*12+1))

1!$A$2:$E$21,INT(RAND()*20+1),INT(RAND
:$Z$21,INT(RAND()*20+1),INT(RAND()*12+1)),IND
AND()*20+1),INT(RAND()*5+1))&INDEX(Sheet1!$O$
NT(RAND()*12+1))&INDEX(Sheet1!$O$2:$Z$21,INT(
+1)))

()*20+1),INT(RAND()*5+1))&INDEX(Sheet1
1),INT(RAND()*12+1))