如何设计一个excel随机函数,生成1-31之间的随机整数,但剔除一些特定整数...答:用VBA代码如下(不会重复,不会出现特定数10):Sub rnd()Dim a As Integer, b As Integer, c As Integer T1:a = Application.RandBetween(1, 31)b = Application.RandBetween(1, 31)c = Application.RandBetween(1, 31)If Application.Or(a = b, a = c, b = c,a=10,b=10,c=10) ...