¸ê®Æ¥Ñª½¦V±Æ¦C, Âର¾î¦V±Æ¦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±Æ¦C, Âର¾î¦V±Æ¦C
¦p¦ó¯à°÷§âexcelªº¸ê®Æ¥Ñª½¦V±Æ¦C, Âର¾î¦V±Æ¦C ???? thx !!!
ªþ¤Wªþ¥ó
Âà¾î¦V®æ¦¡.rar (3.35 KB)
|
|
|
|
|
|
|
- ©«¤l
- 32
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 46
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- °ª¶¯
- µù¥U®É¶¡
- 2010-5-11
- ³Ì«áµn¿ý
- 2021-4-27
|
¥»©«³Ì«á¥Ñ pesi2884 ©ó 2011-1-29 11:07 ½s¿è
G3=INDEX($A:$A,COLUMN()-5+(ROW()-3)*4,)
µM«á¦b©Ô¦ù |
|
|
|
|
|
|
- ©«¤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
|
¦^´_ 2# pesi2884
¤£¦n·N«ä, §Ú¤£¤Ó©ú¥Õ³o¤½¦¡ªº¸Ñªk ? ¨Ò¦p:¬°¦ón -5 , -3, *4 ?????????? |
|
|
|
|
|
|
- ©«¤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
|
¦³¨S¦³¤@¨Ç¸û¬°Â²³æªº°µªk©O ??? |
|
|
|
|
|
|
- ©«¤l
- 32
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 46
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- °ª¶¯
- µù¥U®É¶¡
- 2010-5-11
- ³Ì«áµn¿ý
- 2021-4-27
|
¦^´_ 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! |
|
|
|
|
|
|
- ©«¤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
|
¥Îtranspose¤½¦¡¥i¦æ¶Ü ?
¦ý§Ú¥u·Q¨ì§â««ª½Âର¾î¦V, ¦ý«ç¼Ë¤~¯à«ü©w4Ó, 4Ó¤@¦C©O ???? |
|
|
|
|
|
|
- ©«¤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
|
¦^´_ 6# pesi2884
¬°¬Æ»òn*4 ©O ?????? thx !!! |
|
|
|
|
|
|