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

[µo°Ý] ¸ê®Æ·j´M¤ñ¹ï³B²z

[µo°Ý] ¸ê®Æ·j´M¤ñ¹ï³B²z

RR123.rar (2.24 KB)
§Ú³Ìªñ¹J¨ì§xÃø¡A§Ú·Q¼gªº¥\¯à´N¬O·j´MAÄæ¸ò CÄ檺ID­Y¤@¼Ë²Ä¤GÄæB¸òD ªº¸ê®Æ§@­pºâ¡A
¥HAÄ欰°ò·Ç¡A­Y§ä¤£¨ìCÄæID¸ê®Æ¡A«h¨S°Ê§@

¦^´_ 1# winshiang

       ·j´MAÄæ¸òCÄ檺ID­Y¤@¼Ë
=> ²Ä¤GÄæB¸òD ªº¸ê®Æ§@­pºâ(?)

§@«ç¼Ëªº­pºâ,½Ð¦bexcelÀɮפº¼g¥X­pºâµ²ªG¨Ã»¡©ú¦p¦ó­pºâ

TOP

UPDATE RR123.rar (2.32 KB)

©êºp§Ú§ó·s¡A§Ú·Q¼gªº¥\¯à´N¬O·j´MAÄæ¸ò CÄ檺ID­Y¤@¼Ë²Ä¤GÄæB¸òD ªº¸ê®Æ§@­pºâ(Earnings: «á­±ªº¼Æ¦r¡A¨Ò¦p A1=C3, ¨º»òD3-B1 ,0.7200-0.6200=0.1000 )¡A
¥HAÄ欰°ò·Ç¡A­Y§ä¤£¨ìCÄæID¸ê®Æ¡A«h¨S°Ê§@

TOP

¦^´_ 3# winshiang

E1=IF(ISNA(VLOOKUP(A1,$C$1:$D$19,2,0)),"",MID(VLOOKUP(A1,$C$1:$D$19,2,0),45,6)-MID(B1,45,6))
©¹¤U½Æ»s

TOP

UPDATE RR123.rar (2.55 KB)
¤j¤j©êºp¡A§Ú®M¥Î¤W¥h¥u¦³²Ä¤@­Ó¥i¥Hºâ¡A²Ä¤G­Ó¥H«á´N¤£¦æ¤F¤]¡H

TOP

¦^´_ 5# winshiang

«ç¨Sºâ,µª®×0¤]¬O¦³ºâ
§A©Òµ¹ªº¼Æ¾Ú,ºâ¥X¨Ó³£0

TOP

¤F¸Ñ¡A^^  ¡A¬ðµM§Ñ°O¼Æ¦r¤@¼Ë

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD