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

¤£¦P¤u§@ªíªº­È

¤£¦P¤u§@ªíªº­È

§Ú²{¦b¥d¦b¦³¨â­Ó¤u§@ªí¡A§Ú­n¦b¤u§@ªí1§Q¥Î¤½¦¡(=¤u§@ªí2!A6)
§â¤u§@ªí2ªº­È¥i¥Hª½±µ¦b¤u§@ªí1Åã¥Ü¥X¨Ó
°ÝÃD¬O¡G
¤u§@ªí2ªº­È¬O¨C4®æ¤~¬O§Ú­nªº­È(A6¡BA10¡BA14¡BA18¥H¦¹Ãþ±À)
¦b¤u§@ªí1µLªk¥HÀx¦s®æ¥k¤U¨¤¥X²{ªº¤Q¦r²Å¸¹¤U©Ô¤è¦¡Åã¥Ü¥X¨C4®æªº­È
½Ð°Ý³o¦³¿ìªk¸Ñ¨M¶Ü??

¦^´_ 1# 29249946

play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ ymes ©ó 2011-8-28 21:11 ½s¿è

§Ú·Q¡A§Aªº°ÝÃDµª®×À³¸Ó¬O³o­Ó§a
B2=OFFSET(Sheet2!$A$6,ROW(A1)*4-4,0)
¥¿¦n³o´X¤Ñ¤]°Ý¤F¬Û¦üªº°ÝÃD¡A©Ó»XHsieh ¤j¤j±Ð¾É¡A¥¿¦n¨Ó²{¾Ç²{½æ

002.gif (9.38 KB)

002.gif

~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

°Ñ¦Ò¥Î=INDEX(A:A,4*ROW()-2)

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD