ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

excel¬O§_¥i¥H¦³ÀH¾÷©â¼úªº¥\¯à

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-8-7 13:55 ½s¿è

¦^´_ 14# emma


¶Ç¦^±z«ü©wªº¼Æ¦r¤§¶¡ªº¥ô·N¤@­Ó¶Ã¼Æ¡C¦b¨C¦¸­pºâ¤u§@ªí®É¡A³£·|¶Ç¦^¤@­Ó·sªº¶Ã¼Æ¡C
¦pªGµLªk¨Ï¥Î¦¹¨ç¼Æ¡A¥B¶Ç¦^ #NAME? ¿ù»~¡A½Ð°õ¦æµ{¦¡¥H¦w¸Ë¡u¤ÀªR¤u¨ã½c¡v¡C

TOP

¥»©«³Ì«á¥Ñ emma ©ó 2010-8-5 16:04 ½s¿è

ÀH¾÷©â¼ú´ú¸Õ990805.rar (15.23 KB) ¦^´_ 20# asimov


asimov ¤j¤j¡A±z¦n~~
Ãö©ó±z©Ò´£¨Ñªº¤è¦¡¡A¤@¦¸¥u©â¥X¤@¦ì±o¼ú¤Hªº®ÄªGÁÙº¡§l¤Þ§Úªº¡A
¦ý¤£ª¾¬°¦ó¡A§Ú©Ò´ú¸Õ¥X¨Óªºµ²ªG¬O¡A¤£®e©ö²£¥Í­«½ÆªºID¡A
¦ýÁÙ¬O·|¦³²£¥Í­«½ÆIDªº±¡ªpµo¥Í¡A
¥t¥~¡A§ÚªºID¥Ø«e¬O°²³]©Êªº¥H1¡B2¡B3...³oºØÃþ¦ü§Ç¸¹ªº½s±Æ¤è¦¡
¦ý¹ê»ÚÀ³¥Îªº¸Ü¡AÀ³¸Ó¬O·|¹³¨­¥÷ÃÒ¸¹³oÃþ¦³­^¤å¦r¶}ÀYªºID¨Ó®M¥Î¡A
¨º»ò=INT(RAND()*(COUNTA($B$2B$56)-COUNTA($F$2F$17)))+1
­n¦p¦ó­×¥¿¤~¥i¥H¹F¨ìª½±µ±a¥X±o¼ú¤H¬O½Ö(¨­¥÷ÃÒ¸¹©Î©m¦W)ªº®ÄªG?
990805TEST2.jpg
2010-8-5 13:36


PS.±z¦n¡A¦Aªþ¤W¸û·sªºªþ¥ó¡AÁÂÁÂ!!

TOP

¦^´_ 22# emma


   
3.jpg
2010-8-5 15:16

TOP

¦^´_ 22# emma


­ì20¼Ó¦^ÂÐ I5 ¤§¤¤¼ú¤HID¤½¦¡¤Ö¤@­Ó°Ê§@
¥¿½T¬°=VLOOKUP(INT(RAND()*(COUNTA($B$2:$B$56)-COUNTA($F$2:$F$17)))+1,$A$2:$B$56,2,0)

¨Ì±z­×§ï«áªºÀÉ®× F22 ¤½¦¡¬°
=VLOOKUP(INT(RAND()*(COUNTA($B$2:$B$56)-COUNTA($I$2:$I$17)))+1,$A$2:$B$56,2,0)

¹ê»ÚÀ³¥Î,«Øij§R°£ BÄæ"§Ç¸¹"
§ï¥H"ID","·|­û½s¸¹"©Î"±m¨é¸¹½X"¨ú¥N
¦ý¶·ª`·N¥H¤W¤T¶µ³£¤£¥i­«½Æ
¦p¤@¤H¥i¦³¦h¦¸©â¼ú¾÷·|
«h¥H"±m¨é¸¹½X"¬°©y
ÀH¾÷©â¼ú´ú¸Õ(¤£­«½Æ)_1.zip (5.13 KB)

©â¼úµ{¦¡_1.jpg
2010-8-6 01:59
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

­n³]©w¦h©ó¤@­Ó¾÷·|, ¥Î¥¨¶°¤ñ¸û®e©ö³B²z

Prize.zip (7.88 KB)
  1. Sub jjj()
  2.    
  3.     Range("f1..h1000").Clear
  4.     Range("f1").Value = "id"
  5.     Range("g1").Value = "name"
  6.    
  7.    
  8.     k = 2   'first row to fill in value is 2.
  9.     For Each i In Range("c2:c1000")
  10.         For j = 1 To i.Value
  11.             Cells(k, 6).Value = i.Offset(, -2).Value
  12.             Cells(k, 7).Value = i.Offset(, -1).Value
  13.             Cells(k, 8).Value = Rnd()
  14.             k = k + 1
  15.         Next
  16.     Next
  17.    
  18.     Range("f1:h1000").Select
  19.     Selection.Sort Key1:=Range("h2"), Order1:=xlAscending, Header:=xlGuess, _
  20.         OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
  21.    
  22.     Range("h:h").Clear
  23. End Sub
½Æ»s¥N½X

TOP

«D±`ÁÂÁÂPD961A¡Basimov¡Bivanyung¡BPD961A¡Bgong¤ÎGBKEE ¦U¦ì¥ý¶i­Ìªº¨ó§U¡A
¥Ø«eÃö©ó¦¹°ÝÃD¡A¥Ñ¦U¦ì¥ý¶i¨ó§UÀ°¦£¤U¡A¤wºî¦X¨ú±o¸û¨Îªº¨Ï¥Î¤è¦¡¡AÁÂÁ¤j®a!!

TOP

¥H©T©w¦¸¼Æ¨Ó»¡¡A8¼Óªº°µªk¬O³Ì¦nªº¡A
¦h©ñ´X¤äÅÒ¡A¶Ã¼Æ±Æ§Ç«á¬D¥X«e­±ªº¶µ¥Ø¡C³o¼Ë´N¥i¥H¦¬¤u¤F¡C
¥t¤@ºØ¤è¦¡¬O³]©w¨CºØ¼ú¶µªº¾÷²v¤Î¨C­Ó¤Hªº¶Ã¼ÆÅv­«¡A¥Ñ¶W¹LªùÂe­Èªº¤H²Õ¦¨­Ô¿ï¦W³æ¡C
¦³ªºªø©x¤£»Ý­n¨º»ò¦Û°Ê¤Æ¡A·|·Q±q¦W³æ¬D... ©â¼ú¤]¬O«Ü±Ó·Pªº¥ô°È©O¡C

TOP

¥H¤W¨ü¥Î«Ü¦h~~

§Ú·Q½Ð°Ý~¦pªG§Ú·Q¥Î­Ócommend¶s¨Óµ¥©óF9ªº§ó·s
¸Ó¦p¦ó³]©w?

­Y¦b¦P¤@­Ó¤u§@ªí¤¤~¦³4¤j¶µ¶i¦æ©â¼ú~
²Ä¤@¶µ¤w©â¼ú¡A­Y¦b¶i¦æ²Ä¤G¶µ©â¼ú®É~
¥ÎF9§ó·s·|¦P¨B±N²Ä¤@¶µªº¼ú¶µ¦W³æ¤S¬~±¼¤F..
¸Ó¦p¦ó¶i¦æ³]©w©O??

TOP

½Æ»s/¶K¤W­È
«O¯dµ²ªG
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

thx a lot!  let me try it
Sushi

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD