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

[µo°Ý] ¬d¸ß²£«~¼Æ¶q

DEAR Hsieh:
¤j¤j

§Ú¬O§Æ±æ

       (¥x¥_¥X³f1 + ¥x¥_¥X³f2)  -  ·~°È­ûªº (¶i³f¼Æ¶q1+¶i³f¼Æ¶q2)   = ®w¦s®tÃB
ex.    ( 100   +  0 )  - (  50  +   60 ) =   -10
          (  60  + 60  )  - ( 100  +20  )  =    0
          (  50  + 50  ) -  (  40  + 40   )  = +20

¥t¥~ . ¦Û°Ê½s¸¹ ¿é¤J ·s¼W ´N¦Û°Ê²£¥Í
§R°£¾ã¦C ¬O«ü   ¦pªG²Ä 10¦C ¤£­n ´N§R°£ ²Ä10¦C

ÁÂÁ«ü±Ð
owen

TOP

DEAR ¤j¤j:

¦Û°Ê½s¸¹ ¦³°µ¥X
¦ý¬O µLªk¬Û®e


¬d¸ß ¤£·|°µ

¥t¥~,­ì¥»ªº ªí³æ¿é¤J   (®w¦s®tÃB) ¨ú®ø±¼
¥Î ¤½¦¡ ¥N´À

®w¦s¿é¤J­pºâ0907.rar (15.34 KB)

owen

TOP

¦^´_ 12# owen9399
(¥x¥_¥X³f1 + ¥x¥_¥X³f2)  -  ·~°È­ûªº (¶i³f¼Æ¶q1+¶i³f¼Æ¶q2)   = ®w¦s®tÃB ³o®w¦s®tÃBªº¤½¦¡¦³ÂI©Ç,
®w¦sÃBªº¤½¦¡,À³¸Ó¬O= ¶i³f - ¥X³f
¦Û°Ê½s¸¹ªºµ{¦¡½X,ªþÀɤ¤¨S¦³¬Ý¨ì.
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

½Ð°Ý ¥Ñ¤u§@ªí¥kÃä³Ì«á¤@­Ó¦³¸ê®Æ¬O¦p¦óªí¥Ü¡A¤¤¶¡¦³ªÅ¥ÕÄæ
ÁÂÁÂ

TOP

¦^´_ 14# wufonna
  1. Sub Ex()
  2.     Dim I As Integer
  3.     With ActiveSheet
  4.         .Cells(1, .Columns.Count).End(xlToLeft).Select
  5.         '²Ä1¦C ¥Ñ³Ì¥kÃä(³Ì«á¤@øó: Columns.Count ),©¹¥ª¦³¸ê®ÆªºÀx¦s®æ
  6.     End With
  7. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

ÁÂÁÂ G¤j ^0^

TOP

A3=IF(OR(A2="",B3=""),"",A2+1)
A4
A5
....©¹¤U©Ô


ª½±µ©óªí³æÅã¥Ü
¦ý¬O «ö¤U¿é¤Jªí³æ «o¸õ¹L

µLªk ¾ã¦X¦b¤@°_
owen

TOP

¥»©«³Ì«á¥Ñ owen9399 ©ó 2013-9-10 13:19 ½s¿è

³¡¥÷¹F¦¨§Ú­nªº¥Ø¼Ð¤F

¦ý¬O
¬d¸ß »P §R°£¦C ¤£·|


¦pªþ¥ó

ÁÂÁÂ

102¿é¤J¹ï±b³æ0910.rar (1.82 KB)

owen

TOP

[µo°Ý] ¬d¸ß²£«~¼Æ¶q

DEAR ¤j¤j:

¦p¦ó¬d¸ß ²£«~¼Æ¶q

¦pªþªí

¬d¸ß²£«~¼Æ¶q0910.rar (7.33 KB)

owen

¦^´_ 18# owen9399
ªþÀɨS¦³¤@ÂIµ{¦¡½X??
12# ¦³°Ý§A¦Û°Ê½s¸¹ªºµ{¦¡½X,ªþÀɤ¤¨S¦³¬Ý¨ì.??(¨S¦³¦^ÂÐ,¦p¦ó«ü¾É§A?)
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD