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

½Ð¦U¦ì¤j¼w«üÂI¤@¤U¡A¦p¦ó°µ¥X ¯f¾ú¦C¦L¨t²Î

½Ð¦U¦ì¤j¼w«üÂI¤@¤U¡A¦p¦ó°µ¥X ¯f¾ú¦C¦L¨t²Î

½Ð¦U¦ì¤j¼w«üÂI¤@¤U¡A¦p¦ó°µ¥X ¯f¾ú¦C¦L¨t²Î

¡°¥Ø¼Ð­«ÂI¡G¦b¤£¼vÅT¯ȥ»¯f¾úªº«e´£¤U¡A±N·s¼Wªº¯f¾ú¦C¦L¥X¨Ó¡C

¡°³o¥u¬O¤@­Ó¼ÒÀÀ¡A¨Ã¤£¬O¯uªº¯f¾ú¡A§Ú¤]¤£¬OÂå¥Í¡A¥u¬O¦³»Ý­nÃþ¦üªº¦C¦L¥\¯à


§Ú·|¦³¤@­Ó¨C¤ëÁ`ªí¡A©M¤@­Ó¯f¾úÁ`ªí¡]¥]§t¤@­Ó¦C¦L½d¥»­¶¡A¤Î¥H¯f¤H½s¸¹©R¦WªºSHEET¡^

¨C¤ëÁ`ªí¡A¤w¸g·Ó¯f¾ú½s¸¹¡B¤é´Á±Æ¸¹¡A¥Ø«e¤w¸g¯à±N¨C­Ó¯f¤Hªº¸ê®Æ¡A¤@¤@§ì¥X¡AµM«á¨ì¯f¾úÁ`ªí¡A§ä¥X¨C­Ó¯f¤Hªº SHEET¡ACOPY¨ìSHEET ªº³Ì«á­±¡C

¥Ø«e³o­Ó¾ã²zªº¤u§@OK¡C

±µ¤U¨Ó«h¬O±N¨C­Ó  SHEET ¦C¦L¥X¨Ó¡C¤£¥i¯à¨C­Ó¤ë¤@±i¡A³o¼Ë¦C¦L¥X¨Óªº¸ê®Æ·|«Ü¦h¡C

¥²»Ý±Nªº¯f¾ú¯È©ñ¶i¥h¡AµM«áºò¸òµÛªº¸ê®Æ«á­±¥´¦L¡C

§Ú²{¦bªº·Qªk¬O³o¼Ë¡G¦C¦L­¶¡G


¤@¡B±NSHEET ªº¸ê®Æ ¾ã²z¨ì¦C¦L­¶¡C


¤G¡B¸ò¾Ú ¡y¤w¥´¦L¡z¡A±N¸Ó¦æÃC¦â§ï¦¨¥Õ¦â¡C¡]ÁקK¦C¦L¡^

¤T¡B§ä¥X¥¼¦C¦Lªº¸ê®Æ­¶¡A

¥|¡B¦C¦L¡A±N·s¼Wªº¸ê®Æ¼Ð¥Ü¬°¡y¤w¥´¦L¡z


²{¦b§xÂZ§Úªº¬O

¤@¡B¦p¦ó§ä¥X»Ý­n¦C¦L­¶¼Æ¡A¬O²Ä´X­¶¡H

¤G¡B¡y¦C¦L¼ÐÃD¡z­n¦p¦ó±±¨î¡H¡]´«·s­¶ªº®É­Ô­n¦L¡A¤§«á¤£­n¦L¡^

¯à¤£¯àµ¹ÂI«Øij¡B©Î¬Ýªk
¤½¶}¸gÅç¡A³Ð³y´¼¼z¡]§Ú¤S¤£¾a³o¹L¬¡¡^

¦^´_ 1# eigen
¥²»Ý±Nªº¯f¾ú¯È©ñ¶i¥h¡AµM«áºò¸òµÛªº¸ê®Æ«á­±¥´¦L¡C
À³¸ÓÃþ¦ü,»È¦æ¦sºPªº¸ÉºP¦L¦C,¨º¶·­n¥Î¸ÉºP¾÷¦L¦C.¨S¦³¾Ç²ß¨ì.
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 2# GBKEE


¹ï¡A«Ü¹³¸ÉºP¾÷¡A

¤£¹L¡A¸ÉºP¾÷À³¸Ó¬O¾a¥ú¾Ç±½´y©M¸ê®Æªº°O¿ý¡A±oª¾§A½ªº­¶¼Æ¹ï¤£¹ï¡A¦³¨º¨Ç¸ê®Æ­n¥´¤W¥h¡C

§Ú²{¦b°ß¤@·Q¨ìªº¤è¦¡´N¬O¥Î ROW()¨Ó§PÂ_

·s¼W¦æ¼Æ¦b²Ä´X­¶¡A³Ì«á¤@¦æ¦b²Ä´X­¶¡A

µM«á¦A¨Ó§PÂ_­n¦C¦L¨º´X­¶¡C¨º¨Ç­¶ªº¼ÐÀY­n¦L¡A¨º¨Ç­¶¼ÐÀY¤£­n¦L¡]¥ú¤ÀªR§Ú´N°÷ÀY¤j¤F¡^
¤½¶}¸gÅç¡A³Ð³y´¼¼z¡]§Ú¤S¤£¾a³o¹L¬¡¡^

TOP

¦^´_ 3# eigen


    EXCEL ¤£¬O¥i¥H³]©w­n¦C¦LªºÀx¦s®æ½d³ò

TOP

¦^´_ 3# eigen


    ¨C¤ëÁ`ªí¡A¤w¸g·Ó¯f¾ú½s¸¹¡B¤é´Á±Æ¸¹¡A¥Ø«e¤w¸g¯à±N¨C­Ó¯f¤Hªº¸ê®Æ¡A¤@¤@§ì¥X¡AµM«á¨ì¯f¾úÁ`ªí¡A§ä¥X¨C­Ó¯f¤Hªº SHEET¡ACOPY¨ìSHEET ªº³Ì«á­±¡C
¥Ø«e³o­Ó¾ã²zªº¤u§@OK¡C

http://forum.twbts.com/viewthrea ... =%C1%60%AD%B6%BC%C6
°Ñ¦Ò³o¸Ì ¨úªºÁ`­¶¼Æ
±N¶·¦L¦Cªº¤u§@ªí½Æ»s¨ì·s¼Wªº¤u§@ªí.
·s¤u§@ªí±N¤w¦L¦C¹L½d³òªº¸ê®Æ²MªÅ(¯d¥Õ),¤£¬O§R°£¤w¦L¦C¹L½d³ò.
¥u¦L¦C·s¤u§@ªíªº³Ì«á¤@­¶,
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD