Excel - 随机生成姓名等名义数据
how to randomly generate nominal data?
- 随机选择A,B,C,D,E,F,G中的一个
=CHOOSE(INT(RAND()*7+1),"A","B","C","D","E","F","G")
- 随机选择“Class 1”,"Class 2 ","Class 3"中的一个
=CHOOSE(INT(RAND()*3+1),"Class 1","Class 2","Class 3")
Excel - 随机生成有序数据
在日期范围内随机生成一个日期
- 随机生成2023年某一天的日期
=RANDBETWEEN(DATE(2023, 1, 1),DATE(2023, 12, 31))
- 随机生成1到200中的某一个数字
=RANDBETWEEN(1,200)