Excel怎么从一列或一行数据中随机抽取一个数详解:http://jingyan.baidu.com/article/5d368d1e1a77b73f61c05740.html
输入=INDEX(A:A,RANDBETWEEN(1,20))