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

¸ê®Æ¥Ñª½¦V±Æ¦C, Âର¾î¦V±Æ¦C

¸ê®Æ¥Ñª½¦V±Æ¦C, Âର¾î¦V±Æ¦C

¦p¦ó¯à°÷§âexcelªº¸ê®Æ¥Ñª½¦V±Æ¦C, Âର¾î¦V±Æ¦C ???? thx !!!
ªþ¤Wªþ¥ó
Âà¾î¦V®æ¦¡.rar (3.35 KB)

¥»©«³Ì«á¥Ñ pesi2884 ©ó 2011-1-29 11:07 ½s¿è

G3=INDEX($A:$A,COLUMN()-5+(ROW()-3)*4,)
µM«á¦b©Ô¦ù

TOP

g3=IF((ROW(A1)-1)*4+COLUMN(A1)>COUNTA($A:$A)-1,"",OFFSET($A$1,(ROW(A1)-1)*4+COLUMN(A1),))
¦V¤U¦V¥k½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# pesi2884


¤£¦n·N«ä,  §Ú¤£¤Ó©ú¥Õ³o¤½¦¡ªº¸Ñªk ? ¨Ò¦p:¬°¦ó­n -5 , -3, *4 ??????????

TOP

¦³¨S¦³¤@¨Ç¸û¬°Â²³æªº°µªk©O ???

TOP

¦^´_ 4# yan870510


    G3=INDEX($A:$A,COLUMN()-5+(ROW()-3)*4,)
    ¥HG3Àx¦s®æ¬°¨Ò
   COLUMN()=7 ©Ò¥HCOLUMN()-5=2
     ROW()=3 ©Ò¥H(ROW()-3)*4=0
     INDEX($A:$A,2,)="PETER"

     ¥HJ3Àx¦s®æ¬°¨Ò
   COLUMN()=10 ©Ò¥HCOLUMN()-5=5
     ROW()=3 ©Ò¥H(ROW()-3)*4=0
     INDEX($A:$A,5,)="JUDY"

     ¥HG4Àx¦s®æ¬°¨Ò
   COLUMN()=7 ©Ò¥HCOLUMN()-5=2
     ROW()=4 ©Ò¥H(ROW()-3)*4=4
     INDEX($A:$A,6,)="DAV ID"

     ¤£ª¾¹D³o¼Ë»¡§AÁA¤£ÁA!

TOP

¥Îtranspose¤½¦¡¥i¦æ¶Ü ?
¦ý§Ú¥u·Q¨ì§â««ª½Âର¾î¦V, ¦ý«ç¼Ë¤~¯à«ü©w4­Ó, 4­Ó¤@¦C©O ????

TOP

¦^´_ 6# pesi2884


    ¬°¬Æ»ò­n*4 ©O ?????? thx !!!

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD