excel或则word中,实现随机抽取指定范围的数据答:我有苯苯的方法,就是先分别在A1到A10里面输入=CHOOSE(INT(RAND()*10)+1,"0.5mm/4m","1mm/4m","1.5mm/4m","2mm/4m","2.5mm/4m","3mm/4m","0.5mm/1m","1mm/1m","1.5mm/1m","2mm/1m")&","然后在B1里面输入=A1&A2&A3&A4&A5&A6&A7&A8&A9*A10.确实比较笨,但能实现...
随机在EXCEL或WPS中每列各选取一个数字依次填到不同单元格中,且随机第...答:当E列取值>=38(38,39,40)时,在F列找不到>38的数值(最大值为38)。这样的情况怎样处理?在J1中输入或复制粘贴下列公式 =INDEX(A:A,RANDBETWEEN(1,COUNT(A:A)))在K1中输入或复制粘贴下列公式 =INDEX(B:B,RANDBETWEEN(MIN(IF(OFFSET(B1,,,COUNT(B:B))>J1,ROW(INDIRECT("1:"&COUNT(B:...