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

[µo°Ý] Ãö©óÀH¾÷¿ï¨úªº°ÝÃD~

[µo°Ý] Ãö©óÀH¾÷¿ï¨úªº°ÝÃD~

ÀH¾÷.rar (10.68 KB)
¤p§Ìªºªº°ÝÃD¦pªþ¥ó,Àµ½Ð¤j¤j­Ì«ü¾É~

¦^´_ 1# sujane0701

«Øij¥i¥H±N°ÝÃD ºI¹Ï ©M ²²¤»¡©ú...

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 1# sujane0701
¸Õ¸Õ
ÀH¾÷.zip (16.18 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# Hsieh
½Ð±Ð
  1. =INDEX(rng,,RANDBETWEEN(1,y))
  2. =IF(z=0,"",INDEX(place,RANDBETWEEN(1,n-1),))
½Æ»s¥N½X
»yªkªº²[¸q¬°¦ó¡H
rng¡Bz¡Bplace¡By¡Bn ³£¦b¨º¸Ì©w¸q¡H
ÁÂÁ±z¡I

TOP

¦^´_ 4# c_c_lai


    ³oÃþ¦³¬Û¹ï°Ñ·Óªº©w¸q¤½¦¡¡A³£À³¦b¿ï¨ú±ý¨Ï¥Î¸Ó¦WºÙªºÀx¦s®æ®É¼¶¼g¤½¦¡
2003ª©¥»¦ì¸m:´¡¤J/¦WºÙ/©w¸q
2007¥H«áª©¥»¦ì¸m:¤½¦¡/©w¸q¦WºÙºÞ²z­û
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# Hsieh
­ì¨Ó¦³¦¹¤@¥Î¡A§ÚÁٻݭn¦b Excel »â°ì¤º¦h¤U¤u¤Ò©O¡A
ÁÂÁ«ü¾É¡I

TOP

¦nÃø¾¾...¦n¦h¦a¤è¤£²z¸Ñ,³oÃD°÷§ÚºCºC¬ã¨s¤F
·PÁª©¥D¸Ñµª~

TOP

¦^´_ 2# mark15jill


    ¶â¶â,«D±`¤£¦n·N«ä,§Ú¤£¤Ó¼ô±xºI¹Ï¤u¨ã,¤U¦¸§ï¶i :dizzy:

TOP


¤½¦¡¸ò©w¸q»Pª©¥Dªº¤@¼Ë,½Ð°Ý¥X²{#NAME?ªº­ì¦]?¤p§Ì¥Îªº¬OEXCEL2003,¬O§_¦]¬°ª©¥»¸û©ҥH¤£±µ¨ü???©Î¸Ó¦p¦ó¸Ñ¨M?
·Ð½Ð¤j¤j­Ì«ü¾É~

TOP

À³¸Ó¬ORANDBETWEEN¨ç¼Æ¨S³Q¤Þ¥Î
¤u¨ã/¼W¯q¶°
¤Ä¿ï¤ÀªR¤u¨ã½c§Y¥i
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD