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

[µo°Ý] ½Ð°Ý¦pªG¦³¤£¦P½d³ò¸Ó¦p¦ó§@ÀH¾÷¬D¿ï

[µo°Ý] ½Ð°Ý¦pªG¦³¤£¦P½d³ò¸Ó¦p¦ó§@ÀH¾÷¬D¿ï

ª©¤j¦n
§Ú»Ý­n¦b«ü©w½d³ò¤º©â¼Ë,
½Ð°ÝA2¤ºªº¨ç¼Æ­n¦p¦ó­×§ï,
µM«á§Ú¥i¥H«öF9,~~¼Æ¦r´NÅÜ¡C
ÁÂÁÂ!!

Book4.rar (8.65 KB)

¦^´_ 1# pupai

A1=INDEX(Sheet2!$A$1:$A$76,MATCH(LARGE(Sheet2!$B$1:$B$76,ROW(A1)),Sheet2!$B$1:$B$76,0),)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    ÁÂÁª©¥D
¤@¦¸À°§Ú¶¡±µ¸Ñ¨M¨â­Ó°ÝÃD
·s¦~§Ö¼Ö!!

TOP

¦^´_ 2# Hsieh


    ª©¥D¦n
§Ú¨Ì·Ó§Aªº¤è¦¡»s§@¤½¦¡
¥i¬OÁÙ¬O·|¦³¤@¨Ç¿ù»~
½Ð±Ð¸Ó¦p¦ó­×¥¿
ÁÂÁÂ!!

°ÝÃD.rar (46.97 KB)

TOP

¦^´_ 4# pupai
¬Ý¤£À´§A¨ú¼Ë½d³òªº³W«h¬°¦ó?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# Hsieh


      ¦]¬°¬O¤À²Õ¨ú¼Ë,¦Ó¥B¨C²Õ¨ú¼Ë¤H¼Æ¤£¦P,©Ò¥H¨ú¼Ë½d³ò§Ú¬O¥Î¤â°ÊKEY IN(³o³¡¥÷¨S¦³³W«h),µ{¦¡¤]¨Sªk¥k¤U¨¤¤U©Ô

TOP

¦^´_ 6# pupai

=RANDBETWEEN(³Ì¤p­È,³Ì¤j­È)

A2=RANDBETWEEN(1,76)
A3=RANDBETWEEN(77,164)
A4=RANDBETWEEN(165,220)
....

TOP

¦^´_ 7# register313


  ª©¤j~¤£À´
A2=RANDBETWEEN(1,76)
A3=RANDBETWEEN(77,164)
A4=RANDBETWEEN(165,220)
....
­n©ñ¦b­þ¸Ì??

TOP

¦^´_ 8# pupai

¹êÅç²Õ ¤u§@ªí
A2Àx¦s®æ ¿é¤J =RANDBETWEEN(1,76)    A2Àx¦s®æ·|¶Ã¼Æ²£¥Í1~76¤§¾ã¼Æ
A3Àx¦s®æ ¿é¤J =RANDBETWEEN(77,164)    A3Àx¦s®æ·|¶Ã¼Æ²£¥Í77~164¤§¾ã¼Æ
A4Àx¦s®æ ¿é¤J =RANDBETWEEN(165,220)    A4Àx¦s®æ·|¶Ã¼Æ²£¥Í165~220¤§¾ã¼Æ

¤£ª¾¬O¤£¬O§A­nªº
¤u¨ã/¼W¯q¶° ¤ÀªR¤u¨ã½c ­n¤Ä¿ï

TOP

¦^´_ 9# register313


    ª©¤j
¸Ñ¨M§Úªº°ÝÃD
«D±`ÁÂÁÂ!!

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD