¸ê®Æª½¦V"¤@Äæ"Âର¾î¦V"¦h¦C"
- ©«¤l
- 14
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 22
- ÂI¦W
- 0
- §@·~¨t²Î
- Window
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2010-12-12
- ³Ì«áµn¿ý
- 2011-11-10
|
¸ê®Æª½¦V"¤@Äæ"Âର¾î¦V"¦h¦C"
¦p¦ó¯à§Q¥Îtranspose ¼Æ²Õ¤½¦¡, §âexcel¤¤, §â¸ê®Æª½¦V"¤@Äæ"Âର¾î¦V"¦h¦C" ??? ¦ý¤@©w¥²»Ý§Q¥Îtranspose¼Æ²Õ¤½¦¡ !!!!!! ¤Q¤À·PÁ !!!!
ªþ¤Wªþ¥ó:
Âà¾î¦V®æ¦¡.rar (3.51 KB)
|
|
|
|
|
|
|
- ©«¤l
- 116
- ¥DÃD
- 29
- ºëµØ
- 0
- ¿n¤À
- 232
- ÂI¦W
- 0
- §@·~¨t²Î
- winXp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW¥x¤¤¥«
- µù¥U®É¶¡
- 2010-9-6
- ³Ì«áµn¿ý
- 2023-7-11
|
½Ð°Ýª©¥D
¼Ó¥D¥H§OÓ¥DÃDµo°Ý®É±o¨ìªº¸Ñµª¡A³£¤ñ³o¼Ë¨ÓªºÂ²³æ©öקï
·j¯ÁÃöÁä¦r¬O¤°»ò©O?§Ú§ä¤£¨ìC
ÁÙ¬Oª©¥D¦³Â²³æªº½d¨Ò¥i¥H«ü¾É
ÁÂÁÂ |
|
YOYO
|
|
|
|
|
- ©«¤l
- 37
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 135
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- 6.0
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-6
- ³Ì«áµn¿ý
- 2021-1-30
|
ì¨Ó«ÂI¬O¡u¦]¬°©w¸q¦WºÙ«á¤~·|¥H¾ãÅé½d³ò§@¬°TRANSPOSEªº¤Þ¼Æ¡v¡A©ú¥Õ¤F¡CÁÂÁª©¥D¦^ÂÐ |
|
|
|
|
|
|
- ©«¤l
- 37
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 135
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- 6.0
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-6
- ³Ì«áµn¿ý
- 2021-1-30
|
¦^´_ 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 |
|
|
|
|
|
|