- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2013-12-17 08:56 ½s¿è
¦^´_ 1# p80252588
°²³]¸ê®Æ¦ì©ó¤u§@ªíSheet1¡A¡u²£«~¦WºÙ¡v¦ì©óÀx¦s®æA1¡A¡uºû¥Í¯ÀA¡v¦ì©óÀx¦s®æB1¡A¡u¥¤¯ù¡v¦ì©óÀx¦s®æA2¡A¥¤¯ù¹ïÀ³ªººû¥Í¯ÀA¶q¦ì©óÀx¦s®æB2
Y©ó¤u§@ªíSheet2¤¤¶i¦æ¡u¦æÂà¦C¡v¡A«h
Äæ¦ì¦WºÙ¡G¤u§@ªíSheet2¤§Àx¦s®æB1¤½¦¡=OFFSET(Sheet1!$A$1,COLUMN(A$1),0)¡A¦V¥k½Æ»s¤½¦¡¡C
¦C¦ì¦WºÙ¡G¤u§@ªíSheet2¤§Àx¦s®æA2¤½¦¡=OFFSET(Sheet1!$A$1,0,ROW(1:1))¡A¦V¤U½Æ»s¤½¦¡¡C
¬Û¹ïÀ³¼ÆÈ¡G¤u§@ªíSheet2¤§Àx¦s®æB2¤½¦¡=OFFSET(Sheet1!$A$1,COLUMN(A$1),ROW(1:1))¡A¦V¥k¦V¤U½Æ»s¤½¦¡¡C
§Y¥i±o¡u¦æÂà¦C¡v¤§µ²ªG¡A½Ð°Ñ¦Ò¡I |
|