阅读背景：

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

来源：互联网 

例一

=CHOOSE(RANDBETWEEN(1,6),$A

例一

=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

 


,$A,$A,$A,$A,$A)=CHOOSE(RANDBETWEEN(1,6),$A

例一

=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

 


,$A,$A,$A



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到：
你可能喜欢:
相关阅读:
随便看看: