使用公式：=CHOOSE(RANDBETWEEN(1,4),"张","王","李","赵")&CHOOSE(RANDBETWEEN(1,4),"翠","秀","红","雅")&CHOOSE(RANDBETWEEN(1,4),"玲","芝","艳","琴")
生成多行多列的随机姓名
使用公式：=OFFSET($A$3,RANDBETWEEN(0,18),RANDBETWEEN(0,5))
制作一个随机抽奖小程序，按F9可以刷新数据：
共有19行6列数据，所以设置偏移的行数最小值为0，最大值为18，偏移的列数最小值为0，最大值为5就可以了。