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

[µo°Ý] ¸ó¤u§@ªí¨ú¥X¸ê®Æ¦X¨Ö°ÝÃD

[µo°Ý] ¸ó¤u§@ªí¨ú¥X¸ê®Æ¦X¨Ö°ÝÃD

¦U¦ì¥ý¶i¦n¡I
¦³¥H¤U°ÝÃD·Q½Ð¤H¨ó§U ¡F

½d¨ÒÀɤº®e : ¦³¤u§@ªíA¡AB¡AC¡A¦U¤u§@ªí¸Ì¬Ò§t¦³1Äæ®É¶¡ + 47Äæ¸ê®Æ (Á`¦@48Äæ)¡C

·Q±NA¡BB¡BC¨Ì·ÓA_CH1,B_CH1,C_CH1,A_CH2_,B_CH2,C_CH2.....¦p¦¹±Æ§Ç¡A©ñ¦ÜD¤u§@ªí¸ÌÀY¡C
¥Ø«e§Ú³o¾q¶wªº¸£³U¡A­ì¬O¥´ºâ¥ÎOFFSET±N¦U¤u§@ªíªº¸ê®Æ¦U§O´£¨ú¦¨


A_CH1 blank blank A_CH2 blank blank ...A_CH47  | B_CH1 blank blank B_CH2 blank blank ...B_CH47 |C_CH1 blank blank C_CH2 blank blank ...C_CH47¡A
¦A¶K¦¨¤W­z©Ò´£ªº¶¶§ÇÂ\©ñ¡F¦ý§Ú§@§¹B¥B±ý±NB¶K¤W®É¡A´N·Q¨ì­ì¥»Àx¦s®æ¦³Aªº¤º®e·|³QªÅ¥Õ®æÂл\±¼¡A¹Á¸Õ¥Î¿ï¾Ü©Ê¶K¤W(¤Ä¿ï²¤¹LªÅ¥Õ®æ)¡A¤]¦æ¤£³q¡C

¤£ª¾¹D§Ú­ì¦³ªº¤èªk¯à§_§¹¦¨¦¹»Ý¨D¡H
§í©ÎªÌ¬O¦³¨ä¥L¤èªk¯à¹F¦¨©O¡H
¦AÀµ¨D¦U¦ì¥ý¶i­Ì¤F¡C

½d¨ÒÀÉ.rar (264.24 KB)

C1 ='CH8_47pcs_Earlier '!D1
D1 =CH8_47pcs_latter!D1
E1 =CH8_47pcs_latter!D1

¿ï¾Ü C1:E1 ½Æ»s
¿ï¾Ü C1:AX1 ¶K¤W
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089


Hello M¤j¡A
§Ú¸Õ§Aªº¤èªk¡Aµ²ªG¬OCH1 CH4 CH7¶¡¶Z¬°¤T¸¹¶¶§Ç¡A¦p¤U¹Ï©Ò¥Ü

¦ý§Ú§Æ±æªº¬OCH1 CH2 CH3 CH4ªº¶¶§Ç¡A¦p¤U¹Ï©Ò¥Ü

TOP

¦^´_ 3# ChuckBucket


C1 =OFFSET('CH8_47pcs_Earlier '!$D1,,(COLUMN(A1)-1)/3)
D1 =OFFSET(CH8_47pcs_latter!$D1,,(COLUMN(A1)-1)/3)
E1 =OFFSET(CH6_47pcs!$D1,,(COLUMN(A1)-1)/3)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD