简单的自动取名公式：连续按F9，可以实现多种名称组合：= CHOOSE(RANDBETWEEN(1,4),"张","王","李","赵") & CHOOSE(RANDBETWEEN(1,4),"翠","秀","红","雅") & CHOOSE(RANDBETWEEN(1,4),"玲","芝","艳","琴") 。。。去重即可。 _新浪新闻

MrExcel

26-04-10 06:59 微博认证：作家代表作《让Excel飞》知名教育博主微博原创视频博主

简单的自动取名公式：连续按F9，可以实现多种名称组合：= CHOOSE(RANDBETWEEN(1,4),"张","王","李","赵") & CHOOSE(RANDBETWEEN(1,4),"翠","秀","红","雅") & CHOOSE(RANDBETWEEN(1,4),"玲","芝","艳","琴") 。。。去重即可。

发布于天津