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

¸ê®Æª½¦V"¤@Äæ"Âର¾î¦V"¦h¦C"

¸ê®Æª½¦V"¤@Äæ"Âର¾î¦V"¦h¦C"

¦p¦ó¯à§Q¥Îtranspose ¼Æ²Õ¤½¦¡, §âexcel¤¤, §â¸ê®Æª½¦V"¤@Äæ"Âର¾î¦V"¦h¦C" ??? ¦ý¤@©w¥²»Ý§Q¥Îtranspose¼Æ²Õ¤½¦¡ !!!!!! ¤Q¤À·PÁ !!!!
ªþ¤Wªþ¥ó:
Âà¾î¦V®æ¦¡.rar (3.51 KB)

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

¦^´_ 1# yan870510

©óF3¿ï¨úª¬ºA¤U©w¸q¦WºÙx
=OFFSET(Sheet1!$A$1,(ROW(Sheet1!A1)-1)*4+1,,4,)
¿ï¨úF3:I3¿é¤J
=TRANSPOSE(x)
CTRL+SHIFT+ENTER§¹¦¨¿é¤J°}¦C¤½¦¡
¦V¤U½Æ»s
1

µû¤À¤H¼Æ

    • gong: ¤½¦¡¥X¯«¤J¤Æª÷¿ú + 3
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  yan870510

©óF3¿ï¨úª¬ºA¤U©w¸q¦WºÙx
=OFFSET(Sheet1!$A$1,(ROW(Sheet1!A1)-1)*4+1,,4,)
¿ï¨úF3 ...
Hsieh µoªí©ó 2011-2-7 01:00


Hsieh ª©¥D¡J

±z¦n¡A½Ð°Ý­Y¤£¥Î©w¸q¦WºÙ¡Aª½±µ¿é¤J¥þ¥y¤½¦¡¨ìÀx¦s®æ¡A¯à±o¥X¬Û¦Pµ²ªG¶Ü¡H §Y¬O¦bÀx¦s®æF3¿é¤J¼Æ²Õ¤½¦¡¡u   {[=TRANSPOSE(OFFSET(Sheet1!$A$1,(ROW(Sheet1!A1)-1)*4+1,,4,))}    ¡v
(§Ú¦b§Úªºexcel2007¸Õ¤F¡A¦ý¤£¦¨¥\¡C)

ÁÂÁ½ç±Ð

¯¬·s¦~§Ö¼Ö¡C

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-2-9 07:57 ½s¿è

¦^´_ 3# sklo

ª½±µ¿é¤J¤½¦¡¤£¯à¦¨¥\
¦]¬°©w¸q¦WºÙ«á¤~·|¥H¾ãÅé½d³ò§@¬°TRANSPOSEªº¤Þ¼Æ
ª½±µ¥ÎOFFSET«ü©w½d³ò®É¡AÁ`¬O¶Ç¦^²Ä¤@­ÓÀx¦s®æ¡A©Ò¥H¤£·|¦¨¥\

³o°ÝÃD¥u¬O¦]¬°¼Ó¥Dªº©T°õ¡A«ü©w¨Ï¥ÎTRANSPOSE¨ç¼Æ¨Ó¸Ñ
¨ä¹ê¤§«e¼Ó¥D¥H§O­Ó¥DÃDµo°Ý®É±o¨ìªº¸Ñµª¡A³£¤ñ³o¼Ë¨ÓªºÂ²³æ©ö­×§ï
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

­ì¨Ó­«ÂI¬O¡u¦]¬°©w¸q¦WºÙ«á¤~·|¥H¾ãÅé½d³ò§@¬°TRANSPOSEªº¤Þ¼Æ¡v¡A©ú¥Õ¤F¡CÁÂÁª©¥D¦^ÂÐ

TOP

½Ð°Ýª©¥D
¼Ó¥D¥H§O­Ó¥DÃDµo°Ý®É±o¨ìªº¸Ñµª¡A³£¤ñ³o¼Ë¨ÓªºÂ²³æ©ö­×§ï
·j¯ÁÃöÁä¦r¬O¤°»ò©O?§Ú§ä¤£¨ì­C
ÁÙ¬Oª©¥D¦³Â²³æªº½d¨Ò¥i¥H«ü¾É
ÁÂÁÂ
YOYO

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD