我想用excel生成5000个以内的随机不重复的5位数字,从00000-99999,随机生成,每个单元格放一个数字,不是到是否可以实现。
å¯ä»¥å©ç¨VBAæ¥çæ5000个éæºä¸éå¤ç5ä½æ°åã
软件çæ¬ï¼Office2007
æ¹æ³å¦ä¸ï¼
1.Alt+F11ï¼è¾å ¥ä»£ç å¦ä¸ï¼
Sub m()
For i = 1 To 5000 '1å°5000循ç¯ï¼çæ5000个æ°
eee:
Cells(i, "A") = Int(Rnd() * 50000) 'éæºç产ä¸ä¸ªå°äº50000çæ°
If Cells(i, "A").Value < 10000 Then GoTo eee 'å¦æè¿ä¸ªæ°å°äº10000ï¼éæ°çæ
If Application.WorksheetFunction.CountIf(Range("A:A"), Cells(i, "A")) > 1 Then GoTo eee 'å¦æè¿ä¸ªæ°å·²ç»åå¨äºï¼ä¹éæ°çæ
Next i
End Sub
2.F5æ§è¡ä»£ç ï¼è¿åExcelå¾å°ç»æï¼
或=TEXT(RANDBETWEEN(0,99999),"00000")