我在EXCEL中写了个VBA程序,在A1:J10随机生成100个不同的数。
Sub 宏1()
For i = 1 To 10
For j = 1 To 10
Cells(i, j + 11) = Rnd
Next j, i
For i = 1 To 10
For j = 1 To 10
Cells(i, j) = Application.WorksheetFunction.Rank(Cells(i, j + 11), Range(Cells(1, 12), Cells(10, 21)))
Next j, i
Range("A1:J10").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Columns("L:U").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlToLeft
Range("A1").Select
End Sub