excel¬O§_¥i¥H¦³ÀH¾÷©â¼úªº¥\¯à
- ©«¤l
- 130
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 162
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-7
- ³Ì«áµn¿ý
- 2011-7-16
|
¥»©«³Ì«á¥Ñ asimov ©ó 2010-8-6 02:14 ½s¿è
¦^´_ 14# emma
´£¨Ñ¥t¤@ºØ¤è¦¡
¨C¦¸¥u©â¥X¤@Ó¤¤¼ú¤H (I5Äæ¦ì)
±N¤¤¼ú¤H¨Ì§Ç¶ñ¤JF17,F16,F15
¶ñ¤JF17«öenter«á¦b²£¥Í¤U¤@Ó¤¤¼ú¤H
¶Ã¼Æ²£¥ÍªºID¤£·|«ÂÐ
·íµM¥²¶·É§U»²§UÄæ
ÀH¾÷©â¼ú´ú¸Õ(¤£«½Æ).zip (4.92 KB)
¤w§ó¥¿¶Ã¼Æ¤½¦¡ |
|
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡
|
|
|
|
|
- ©«¤l
- 130
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 162
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-7
- ³Ì«áµn¿ý
- 2011-7-16
|
¦^´_ 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)
|
|
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡
|
|
|
|
|