Excel 随即获得一组数据集中的数据

例一

=CHOOSE(RANDBETWEEN(1,6),$A$1,$A$2,$A$3,$A$4,$A$5,$A$6)


例二

=VLOOKUP(RANDBETWEEN(MIN(MyStrings[ID]),MAX(MyStrings[ID])),MyStrings,2,0)

例三

=INDEX(A:A,RANDBETWEEN(1,3))

Reference

• excel如何从一列中随机选择一个单元格中的数
• How to generate random string from a set of available strings in Excel?