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

[µo°Ý] EXCEL ©â¼Ë

[µo°Ý] EXCEL ©â¼Ë

¤j®a¦n

§Ú»Ý­n©â¼Ë

§Úªº¸ê®Æ®æ¦¡¦p¤U(¨C­Ó¤u§@ªí¬°958Äæ*1226¦C¡A¦@16­Ó¤u§@ªí¡A©R¦W¬°¤u§@ªí1~¤u§@ªí16)

²{¦b§Ú»Ý­n¦b¨C­Ó¤u§@ªí©â¥X500µ§¼Æ¾Ú(©â¥Xªº¦ì¸m»Ý¬Û¦P¡A¦³­Ó­­¨î±ø¥ó¤£¯à©â¨ì¼Æ­È¬°-9999)

±N¨C­Ó¤u§@ªí©â¥Xªº500µ§«ö¤£¦P¤u§@ªí¦WºÙ¨Ó±Æ¦b¤£¦PÄæ¦ì¨Ã²Î¤@©ñ¦b¤u§@ªí17(¤u§@ªí1±Æ¦bÄæ¦ìA¡B¤u§@ªí2±Æ¦bÄæ¦ìB¡B¨Ì¦¹Ãþ±À...)

¤£ª¾¹D¸Ó¦p¦ó¼g©O

·PÁÂ

¦³¨S¦³¤H¥i¥HÀ°§Ú¸Ñµª

TOP

¦^´_ 1# peter800725


±z¨C­Ó¤u§@ªí¦³958Äæ¡A¬O¨º¤@Äæ­n©â¥X500µ§¡A¦Ó³o¤@Ä檺¸ê®Æ«¬ºA¬O¤°»ò??

TOP

¦^´_ 3# ashan0418

¬O¤@­Ó¤u§@ªíÁ`¦@­n©â¥X500µ§¸ê®Æ
¨S¦³­­©w¬O­þ¤@Äæ
À³¸Ó´N¬OªÅ¶¡ÀH¾÷©â¼Ë

TOP

¨C­Ó¤u§@ªí¬°958Äæ*1226¦C¡A¦@16­Ó¤u§@ªí
³o¸ê®Æ¶q«Ü¤j¡A¨Ï¥Î¤½¦¡·|¶]«Ü¤[
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ashan0418 ©ó 2014-12-29 15:28 ½s¿è

¦^´_ 4# peter800725


¸ò±z½T»{¤@¤U¥H¤Uªº°ÝÃD

1. 16­Ó¤À­¶¬Ò¦³958Äæ*1226¦Cªº¼Æ¾Ú¡A­nÀH¾÷©â¥X500µ§
2. ©â¥Xªº¦ì¸m»Ý¬Û¦P¬O«ü¡A­YÀH¾÷©â¨ìªºÀx¦s®æ¬°A1¡A¨º16­Ó¤À­¶A1ªº­È¤£¯à¬°-9999¡A¤~¬O­nªº¸ê®Æ¶Ü??


­Y¥i¥H¡A½Ð±NÀɮפW¶Ç!!

TOP

16­Ó¤À­¶¬Ò¦³958Äæ1226¦Cªº¼Æ¾Ú¡A­nÀH¾÷©â¥X500µ§.rar (247.34 KB)
¸ê®Æ«ü¼ÒÀÀ3­Ó¤u§@ï¡A¤½¦¡¥u©ñ3Äæ¡A½Ð°Ñ¦Ò
¸ê®Æ¤Î¤½¦¡³]¦n«á¡A«öF9­«·s­pºâ(¥Ø«e³]¬°¤â°Ê­pºâ)¡AµM«á¥h³ÜªM©@°Ø¬Ý­Ó¼v¤ù¡C


1. ¤u§@ªíA¡A¬O§ä¥XSheet1~16¦P¦ì¸m¨S¦³ -9999ªÌ¡A¶ñ¤W RAND()       
A1 =IF(OR(N(INDIRECT("sheet"&ROW($1:$16)&"!rc",))=-9999),"",RAND())       
°}¦C¤½¦¡¡A¤U©Ô¥k©Ô       
       
2. ¤u§@ªíB¡A¥Ñ¤u§@ªíA§ä¥X«e500¤j¡A¨ÃÂର¦æ¦C¦ì¸m(¦C*10^4+¦æ)       
A1 =IF(A!A1="","",IF(RANK(A!A1,INDIRECT("A!R1C1:R1226C958",))>500,"",ROW()*10^4+COLUMN()))       
¤U©Ô¥k©Ô       
       
3. ¤u§@ªíC¡AAÄæ±N¤u§@ªíB¤¤¥HSMALL¨Ì¶¶§Ç¨ú¥X¡ABÄæ~QÄæ´N¬°Sheet1~Sheet16ªº¸ê®Æ       
A2 =SMALL(INDIRECT("B!R1C1:R1226C958",),ROW()-1)       
¤U©Ô       
B2 =INDIRECT("Sheet"&B$1&"!"&TEXT($A2,"!R0!C0000"),)       
¤U©Ô¥k©Ô       
       
       
ª`·N! ¤½¦¡­pºâ§ï¬°¤â°Ê¡A¸ê®Æ­×§ï¦n«öF9­«·s­pºâ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ashan0418


  ³o¸Ì¤W¶ÇÀɮצü¥G¦³­­¨î¤j¤p....

TOP

¦^´_ 7# ML089

·PÁ±z¡A¦ý¬O§Úµo²{§Ú¤£¯à¤U¸üªþ¥ó

TOP

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