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

[µo°Ý] ¤¬°Ê¦¡¹Ïªí°ÝÃD

[µo°Ý] ¤¬°Ê¦¡¹Ïªí°ÝÃD

·Q­n°µ¤@­Ó¤¬°Ê¦¡¹Ïªí
¸I¨ì¨â­Ó°ÝÃD
¤@­Ó¬O¤U©Ô¦¡ªí³æ¡@¥t¤@­Ó¬O index ¨ç¼Æ°ÝÃD
³£¼g¦bªþÀɪº EXCEL ¸Ì
§Æ±æ¦³¤H¥i¥HÀ°§Ú¸Ñ¨M¥¦
©Î¬Oµ¹§Ú§ó¦nªº«Øij
ÁÂÁ¡ã

test.rar (14.31 KB)

¦^´_ 1# Genie

©w¸q¦WºÙx
=INDEX(Sheet2!$B$2:$D$8,,Sheet2!$F$2)
¤U©Ô²M³æ 5ªº¿é¤J½d³òx
¿ï¨úSHEET2!H2:H7
¿é¤J°}¦C¤½¦¡
=OFFSET(Sheet1!$A$15,1,(Sheet2!$F$2-1)*7+Sheet2!$G$2,6,)
    test.zip (16.5 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ Hsieh ª©¥D
¦³¦¨¥\°µ¥X·Q­nªº¹Ïªí
«D±`·PÁ¡ã

¤£¹L offest °}¦C¨ç¼Æ¦³°ÝÃD·Q°Ý
½Ð°Ý¦b cols ªºÄæ¦ì¤¤¿é¤J¡u(Sheet2!$F$2-1)*7+Sheet2!$G$2¡v³o¬O¤°»ò·N«ä¡H
¬O§_¥i¥H¸Ñ»¡¤@¤U
ÁÂÁ¡I

TOP

¦^´_ 3# Genie


    ºâ¥XAÄæ¦V¥k´XÄ檺¦ì¸m
(Sheet2!$F$2-1)*7+Sheet2!$G$2
Sheet2!$F$2¬O¿z¿ï¤@ªº¿ï¾Ü¦ì¸m
³o­Ó¼Æ­È´N¬Oa,b,c¦ì©ó¿z¿ï¤@ªº²M³æ¦ì¸m
¦Ó¸ê®Æa,b,c¸s²Õ¬O¥H7Ä欰¤@­Ó¸s²Õ
©Ò¥H¡A¬O¥H7­¿Äæ¼Æ¦V¥k
³o¥u¬O§ä¨ì¸ê®Æ¸s²Õªº²Ä¤@Äæ¦ì¸m
©Ò¥H¦A¥[¤WSheet2!$G$2
´N¬O¸s²Õ¤¤ªº²Ä´XÄæ?
¨º»ò¡A´N·|«ü©w¥X¨â­Ó¿z¿ï°t¦XªºÄæ¦ì
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2011-8-18 15:01): ½ÐÀˬdÀɮסA½Ð¤W¶ÇµLªk¹F¦¨ªºÀÉ®×

¥»©«³Ì«á¥Ñ Genie ©ó 2011-8-18 16:24 ½s¿è

¤£¦n·N«ä
¬Ý¤F Hsieh ª©¥Dªº¸Ñ»¡«á
§Ú¦b¥t¤@­Óªí®æ¤W«oµLªk§â Data ¥¿½Tªº¹ïÀ³¥X¨Ó
§Æ±æ¥i¥HÀ°§Ú¬Ý¬Ý¬O­þÃä¥X¤F°ÝÃD
ÁÂÁ¡I
test.zip (46.39 KB)

¤£¦n·N«ä
Àɮפw­«·s¤W¶Ç¹L

TOP

¦^´_ 5# Genie

ªí®æ¸s²Õ¨Ã¨S¦³·ÓµÛ¤U©Ô¿ï³æ¶¶§Ç±Æ¦C¡A³o·|¼W¥[³Â·Ð
test.rar (41.25 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ Genie ©ó 2011-8-18 19:45 ½s¿è

¤U©Ô¿ï³æªº¶¶§Ç§Ú·Óªí®æ¸s²Õ±Æ¦C¤F
½Ð°Ý±µ¤U¨Ó Data Äæ¦ìªº¨ç¦¡¸Ó«ç»ò°µÅܧó¡H
²{¦b¨Ã¤£¬O7Ä欰¤@¸s²Õ
test.rar (42.57 KB)

TOP

¦^´_ 7# Genie


    §A¤ñ¸û¨â¦¸ªºDATA©w¸q¤½¦¡À³¸Ó´N¯à¤F¸Ñ
test.zip (50.54 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

«D±`ÁÂÁ Hsieh ª©¥D
§Ú¦³¬Ý¥X°ÝÃDÂI¤F
¦Ó¥B§Ú¤S¾Ç¨ì¤F choose ¨ç¼Æªº¥Îªk
ÁÂÁ¡ã

§Ú¤S­«·s¬Ý¤F¤@¦¸¡u©w¸q¦WºÙªº°g«ä¡v
µo²{§Ú±`·|§Ñ°O¥i¥H¥Î©w¸q¦WºÙ¸Ñ¨M°ÝÃD
¬Ý¨Ó§Ú¹ï©w¸q¦WºÙÁÙ¨S¦³¥Î±o«Ü¶¶¤â

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD