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

[µo°Ý] ¸ê®Æªí®æ¯x°}Âà 90 «×

[µo°Ý] ¸ê®Æªí®æ¯x°}Âà 90 «×

±z­Ì¦n¡G

§Ú¦³¤@°ïªí®æ³£»Ý­n±N¸ê®ÆÂà 90 «×

½Ð°Ý¬O§_¦³§Ö³tªº¤èªk¥i¥H¹F¨ì¡H

ÁÂÁ¡I

  1. =INDEX($A:$D,5-COLUMN(A$1),ROW($A1))
½Æ»s¥N½X
¥k¤U©Ô

TOP

¦^´_ 2# kerryzz
¯u¬Oºë²ªº¦n¤èªk~·PÁ¤À¨É!

TOP

¦^´_ 2# kerryzz


±z¦n¡G

¦¹¤½¦¡¥u¦³·í¼Æ­È¦b A1 Àx¦s®æ¥B¸ê®Æ¬° 4 Äæ®É¤è«K¨Ï¥Î
­Y¼Æ­È¸ê®Æ±q K21 Àx¦s®æ¶}©l¡B¸ê®Æ¦³15¦æ®É¡Acolumn & row ªº´N­n¥hºâ­n´î¦h¤Ö­È

½Ð°Ý¦³¨S¦³³q¥Îªº¤½¦¡©Î¥¨¶°¤è«K°µÂà¸m©O¡H

ÁÂÁ¡I

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2015-5-29 18:26 ½s¿è

¦^´_ 4# Genie


=OFFSET(¥ª¤W¨¤,Äæ¼Æ-COLUMN(A1),ROW(A1)-1)

¤½¦¡¤¤»Ý­n­×§ï°Ñ¼Æ¦p¤U
¥ª¤W¨¤$K$21
Äæ¼Æ 15¦æ

=OFFSET($K$21,15-COLUMN(A1),ROW(A1)-1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# Genie

°ò¥»¾Þ§@ªk
    ½Æ»s/¿ï¾Ü©Ê¶K¤W/Âà¸m
°}¦C¤½¦¡
TRANSPOSE
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh


¤£¦n·N«ä
§Ú­nªº¬O¾ã­Óªí®æ¸ê®Æ¶¶®ÉÄÁÂà 90 «×
Âà¸m¤Î TRANSPOSE µLªk¹F¨ì»Ý¨D...

TOP

¦^´_ 5# ML089


¤½¦¡¨Ï¥Î¤W¨S¦³°ÝÃD
«D±`ÁÂÁ¡I¡I¡I

TOP

¦^´_ 6# Hsieh


    ª©¥D¤j¤j~³o­ÓTRANSPOSE ¬Ý°_¨Ó®¼®e©öªº~
   ¦ý§Ú¨Ì¼Ëµe¸¬Äª¤F¤@¤U~~§Ú¥u±o¨ì²Ä¤@­ÓÀx¦s®æ 32 @@ ¨ä¥L³£¨S¦³~~
   ¤£ª¾¹D­þ¨à¨Sª`·N¨ì?

TOP

¦^´_ 8# Genie


¤½¦¡¨Ï¥Î¤W¬O¨S°ÝÃD¡A¦pªGªí®æ¦h´Nµy³Â·ÐÂI¡A¦pªG¥ÎVBA°µ¥X´N§ó¦n¤F¡C

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD