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

µ¹¤pªB¤Í½m²ß¥[ªkªº°ÝÃD

µ¹¤pªB¤Í½m²ß¥[ªkªº°ÝÃD

½Ð±Ð

°ÝÃD1
§Ú¥Î F9 ²£¥ÍÀH¾÷¼Æ­È µM«á¥Î¿ï¾Ü©Ê¶K¤W "­È"
¤£ª¾¹D¦³¨S¦³¿ìªk¤£­n³o»ò³Â·Ð

°ÝÃD2
¨C¤@ÃD¬Q§@µª«á¥ß§YÅã¥Üµ²ªG»P¤À¼Æ
¦³¤°»ò¤è¦¡¥i¥H¥þ³¡ÃD¥Ø°µ§¹«á¤~Åã¥Üµ²ªG»P¤À¼Æ

·PÁ¤j¤j¨ó§U¸Ñ´b:)

¥[ªk½m²ß.rar (3.23 KB)

¥»©«³Ì«á¥Ñ register313 ©ó 2012-3-5 20:25 ½s¿è

¦^´_ 1# dondon1495

°ÝÃD1
¥ÎVBA¸Ñ¨M¥XÃD¤§§xÂZ
  1. Sub ¥XÃD()
  2. For Each R In Union([A3:A22], [C3:C22])
  3.   R.Value = Int(Rnd() * 50)
  4. Next
  5. [E3:E22] = ""
  6. End Sub
½Æ»s¥N½X
1.gif
¥[ªk½m²ß.rar (7.11 KB)

°ÝÃD2
F3=IF(COUNT($E$3:$E$22)=20,IF((A3+C3)=E3,"¡Ô","¡Ñ"),"")

TOP

¦^´_ 2# register313

ÁÂÁ¤j¤j:D

TOP

¦^´_ 3# dondon1495
¤£¶·VBA
¤u¨ã/¿ï¶µ/­pºâ
¤Ä¿ï¤ÏÂйBºâ¡A³Ì°ª¦¸¼Æ¬°1

½Ð¥[¸ü¤ÀªR¤u¨ã½c¼W¯q¶°
¥[ªk½m²ß.rar (4.88 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh

ÁÂÁÂ Hsieh ¤j¤j
¤£¥Î¼gªF¦è³o¬O§Ú§Æ±æªº
¹J¨ì¤@­Ó°ÝÃD
§Ú§âµª®×°Ï Delete ±¼¤§«á
«e­±¤]¥þ¶Ã¤F
¥t¥~´N¬O§Ú´N¤£ª¾¹D«ç»ò¦A¥XÃD¤F:(

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-3-5 23:17 ½s¿è

¦^´_ 5# dondon1495

ÃD¥Ø¤w¬O¶Ã¼Æ
µª®×¿é¤J«á´N¤£·|¦AÅÜ°Ê
§R°£µª®×«á´N­«·s¥XÃD
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# register313

ÁÂÁÂ register313 ¤j¤j

½Ð°Ý§Ú¦pªG¦³¥[ªk»P´îªk2­Ó¤u§@ªí
VBA­n«ç»ò³]©w©O
¥H«e¨S¥Î¹LVBA
¨º­Ó¥XÃD®×§áÁÙ¤£ª¾¹D«ç»ò°µ¥X¨Ó

TOP

¦^´_ 7# dondon1495
1.§¹¦¨¥[,´î¤u§@ªí
2.¥[¤JVBAµ{¦¡
  ¤u¨ã/¥¨¶°/VB½s¿è¾¹
  
  1. Sub ¥[ªk¥XÃD()
  2. UP = 99: LOWER = 0
  3. Sheets("¥[").Select
  4. For Each R In [A3:A22]
  5.    R.Value = Int((UP - LOWER + 1) * Rnd + LOWER)
  6.    R.Offset(0, 2).Value = Int((99 - R.Value - LOWER + 1) * Rnd + LOWER)
  7. Next
  8. [E3:E22] = ""
  9. End Sub
  10. Sub ´îªk¥XÃD()
  11. UP = 99: LOWER = 0
  12. Sheets("´î").Select
  13. For Each R In [A3:A22]
  14.    R.Value = Int((UP - LOWER + 1) * Rnd + LOWER)
  15.    R.Offset(0, 2).Value = Int((R.Value - LOWER) * Rnd + LOWER)
  16. Next
  17. [E3:E22] = ""
  18. End Sub
½Æ»s¥N½X
3.¥[¤J°õ¦æ«ö¶s
1.gif

TOP

¦^´_ 6# Hsieh

ÁÂÁÂ Hsieh ¤j¤j
¤ÏÂЬݤF¦n¤[
²×©ó¬Ý¨ì¤@ª½º|¬Ýªº´X­Ó¦r
"½Ð¥[¸ü¤ÀªR¤u¨ã½c¼W¯q¶°"
Åý±z¨£¯º¤F
¦A¦¸ÁÂÁ±z^^

TOP

¦^´_ 8# register313

ÁÂÁÂ register313 ¤j¤j
¯uªº§¹¥þ¤£·|VBA
¬ã¨s¤F¦n´X­ÓÄÁÀY
ÁÙ¬O¥u¯à¨Ì¼Ëµe¸¬Äª
ÁöµM§Ú·d¤£¥X¦W°ó
ÁÙ¬O¤Q¤G¸U¤À·PÁÂ
ÁÂÁ¤j¤j^^

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD