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

[µo°Ý] ¤p¾Ç¥Í°ÝÃD 4 (ÁÂÁÂ)

[µo°Ý] ¤p¾Ç¥Í°ÝÃD 4 (ÁÂÁÂ)

¥»©«³Ì«á¥Ñ binargoo ©ó 2011-7-13 18:04 ½s¿è

½Ð±Ð§Ö³t²¾°Ê¥t¸m¤èªk¡H

³]¸ê®Æ½d³òSheet1 A1¡GD3600¡A±ø¥ó¨C¶¡¹j¥|¦C¬°¤@²Õ¾ã¦C²¾°Ê¡C

¨Ò¡GSheet1 A1,A5,A9...,A3597 ²¾°Ê¦ÜSheet2 A1¡GD900¡C
¡@¡@Sheet1 A2,A6,A10...,A3598 ²¾°Ê¦ÜSheet2 F1¡GI900¡C
¡@¡@Sheet1 A3,A7,A11...,A3599 ²¾°Ê¦ÜSheet2 K1¡GN900¡C
¡@¡@Sheet1 A4,A8,A12...,A3600 ²¾°Ê¦ÜSheet2 P1¡GS900¡C

Excel ¦p¦ó¤U«ü¥O¡H·q½Ð¦Ñ®v«e½ú­Ì½ç±Ð¡CÁÂÁ¡I
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

a1=OFFSET($A$1,(ROW()-1)*4,COLUMN(A1)-1)
f1=OFFSET($A$1,ROW()*4-3,COLUMN(A1)-1)

TOP

a1=OFFSET($A$1,(ROW()-1)*4,COLUMN(A1)-1)
f1=OFFSET($A$1,ROW()*4-3,COLUMN(A1)-1)

·PÁ ANGELA ª©¤j¦Ñ®v«e½ú§Ö³t¦^ÂСA¤W­z " ¶Ç¦^°Ñ·Ó¦ì§}¨ú±o¦C¼ÆÄæ¼Æ½d³ò¡B¶Ç¦^¦C¸¹¤Î°Ñ·Ó¦ì§}¤§Ä渹 " ¦³ÂI·§©À¤]¦³ÂI·d²V¡AÀµ½ÐÀ°¾Ç¥Í°µ¨Ç»¡©ú«ü¤Þ¡C¦A¦¸·PÁ¡I
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

a1=OFFSET($A$1,(ROW()-1)*4,COLUMN(A1)-1)
f1=OFFSET($A$1,ROW()*4-3,COLUMN(A1)-1)

·PÁ ANGELA ª©¤j ...
binargoo µoªí©ó 2011-7-13 11:50


a1=OFFSET(SHEET1!$A$1,(ROW()-1)*4,COLUMN(A1)-1)
A1®É ROW() ·|µ¥©ó1 ,COLUMN(A1)¤]µ¥©ó1 ©Ò¥Ha1=OFFSET(SHEET1!$A$1,0,0)
a2®É ROW() ·|µ¥©ó2,COLUMN(A2)=1  ©Ò¥Ha2=OFFSET(SHEET1!$A$1,4,0)
b1®É ROW() ·|µ¥©ó1 ,COLUMN(b1)=2©Ò¥Hb1=OFFSET(SHEET1!$A$1,0,1)
b2®É ROW() ·|µ¥©ó2,COLUMN(b2)=2  ©Ò¥Hb2=OFFSET(SHEET1!$A$1,4,1)
¨ä¾l¦P²z

TOP

¦A¦¸·PÁ ANGELA ª©¤j¦Ñ®v«e½ú¦^ÂСA¾Ç¥Í­ì²z©ú¥Õ¤F¦A¦¸ÁÂÁ¦Ѯv»¡©ú¡C
±ß¤W¦^®a´N¥i¸ÕµÛ°µ°µ¡C
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

¥»©«³Ì«á¥Ñ binargoo ©ó 2011-7-14 10:58 ½s¿è

a1=OFFSET($A$1,(ROW()-1)*4,COLUMN(A1)-1)
f1=OFFSET($A$1,ROW()*4-3,COLUMN(A1)-1)


¦A¦¸½Ð±Ð ANGELA ª©¤j¦Ñ®v©Îª©¤W½Ñ¦Ñ®v«e½ú­Ì¡A¤W¶µ¤èªk¾Ç¥Í¤w¯à³e³q¹B¥Î¡A±©¥t©µ°ÝÃDµLªk§JªA¡C
­Õ±ý©ó·s­¶ Sheet2 A1¦C¡A·s¼W´¡¤J¼ÐÃD¦C©Î¨ä¥L¹Bºâ¦C¡A«h Sheet2 ©Ò¦³¸ê®Æ¥þ¶]±¼¡C¾Ç¥Í¸Õ¤F°Å¶K´¡¤J¡B½Æ»s¼ÐÃD¦Cµ¥­Y¤z¤èªk¬ÒµLªk§JªA¡A°ß¦³¦A¦¸½Ð±Ð¦Ñ®v«e½ú­Ì¡A´Á¬ß´f¤©«ü¾ÉÁÂÁ¡C
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

²Ä¤@­Ó¦ì¸mªº¤½¦¡¤¤
­ì¥»¨Ï¥ÎROW()§ï¦¨ROW(A1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁ Hsieh ¶Wª©¤j¦Ñ®v«e½ú¼ö¸Û¦^ÂСA¤U¯Z¦^®a¸Õ¸Õ¡C
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

¥»©«³Ì«á¥Ñ binargoo ©ó 2011-7-15 00:20 ½s¿è

±ý©ó·s­¶ Sheet2 A1¦C¡A·s¼W´¡¤J¼ÐÃD¦C©Î¨ä¥L¹Bºâ¦C¡A«h Sheet2 ©Ò¦³¸ê®Æ¥þ¶]±¼¡C

®M¥Î

²Ä¤@­Ó¦ì¸mªº¤½¦¡¤¤
­ì¥»¨Ï¥ÎROW()§ï¦¨ROW(A1)



½Ð±Ð½Ñ¦Ñ®v«e½ú¡A¸ê®ÆÁÙ¬O·|¶]±¼¡C






Test001.rar (4.46 KB)
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-7-15 08:52 ½s¿è

ÁקK°Ñ·ÓÀx¦s®æ³Q§R°£©Î²¾°Ê
±N°Ñ·Ó¦ì¸m©ñ¨ì¨Ó·½¸ê®Æªí¤W
¥u­nSheet1Àx¦s®æ¨SÅܰʦì¸m´N¤£³Q¼vÅT
sheet3!A4=OFFSET(Sheet1!$A$1,(ROW(Sheet1!$A1)-1)*4,COLUMN(Sheet1!A$1)-1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD