¶Ã¼Æ±a¤JRAND¡A¦p¦ó¸Õºâ¥X¤p¼ÆÂI«á­±³£¥h±¼

§d¼ü¼ü

½Ð°Ý¦U¦ì¤j¤j¡ã¡ã
¥H¤U¹Ï¥Ü·Q°Ý¡A¦p¶Ã¼Æ±a¤J=RAND()*(215-(1))+(1).......     EXCELÀx¦s®æ¤º¦p¦ó¸Õºâ¥X¤p¼ÆÂI«á­±³£¥h±¼??
§Ú¤£·Q¥HÀx¦s®æ¦U¦¡->¼Æ­È->¤º³]©w

­þ­Ó¤j¤j¥i¥H±Ï§Ú~~[attachimg]32247[/

§d¼ü¼ü

¦^´_ 8# ML089


    ÁÂÁ¿߿ߤj¤j~~~

ML089

¦^´_ 6# §d¼ü¼ü

Sub ex1()
    '¶Ã¼Æ­pºâ«á¨ú¾ã¼Æ
    Range("A7:A26") = "=int(rand()*(215-(1))+(1))"
    Range("A7:A26") = Range("A7:A26").Value

    '±Æ§Ç
    Range("a7:a26").Sort key1:=Range("a7"), order1:=xlAscending, Header:=xlNo
   
    '¨ú°ß¤@
    ActiveSheet.Range("A7:A26").RemoveDuplicates Columns:=1, Header:=xlNo
End Sub

hcm19522

https://blog.xuite.net/hcm19522/twblog/589216489

§d¼ü¼ü

¦^´_ 5# ML089


    ÁÂÁ¿߿ߤj¤j¡ã~~  ­þ¥i¥Hµ{¦¡¥[¤W¤£­«½Æªº¼Æ¶Ü?¡@¤]´N¬O»¡¶Ã¼Æ¡Ï¤£­«½Æ¡Ï±Æ§Ç

ML089

¦^´_ 1# §d¼ü¼ü

Sub ex1()
    '¶Ã¼Æ­pºâ«á¨ú¾ã¼Æ
    Range("A7:A26") = "=int(rand()*(215-(1))+(1))"
    Range("A7:A26") = Range("A7:A26").Value

    '±Æ§Ç
    Range("a7:a26").Sort key1:=Range("a7"), order1:=xlAscending, Header:=xlNo
End Sub

ML089

¦^´_ 1# §d¼ü¼ü

Sub ex1()
Range("A7:A26") = "=int(rand()*(215-(1))+(1))"
Range("A7:A26") = Range("A7:A26").Value
End Sub

§d¼ü¼ü

¦^´_ 2# ikboy


  ¤j¤j~~  µLªk¤]!!!

ikboy

1. int(Rand().........)

½Æ»s¥N½X