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

Â^¨ú¯S©w¦r¦ê¨Ã¥Î­Èªí¹F¤À¨É¨Ã½Ð¯q

Â^¨ú¯S©w¦r¦ê¨Ã¥Î­Èªí¹F¤À¨É¨Ã½Ð¯q

¦U¦ì¤j¤j¡A¤pªºµo²{¤@­Ó¨ç¼Æ¦p¤U:

A1 = 04/01_AAA¦¬¤J4061.34

B1 =SUM(RIGHT(B4,LENB(B4)-13))


½Ð°Ý¦U¦ì¤j¤j¡A§Ú·Q½Ð°ÝSUM³o­Ó¨ç¼Æ¡A¥i±j¨î±NºI¨ú¥X¨Óªº¦r¦êùØÀY¤§¼Æ¦r·í§@­È¡A³o¼Ëªº¸ÑÄÀ¡A½Ð°Ý¦X²z¶Ü?

­Y«e­±¦r¤¸¼Æ©T©w¡G
=--RIGHT(A1,LEN(A1)-11)
=--MID(A1,12,19)

­Y¼Æ¦r©T©w¦b«á­±¡G
=-LOOKUP(,-RIGHT(A1,ROW($1:$19)))

³oÃþ°ÝÃD¡A¨ì¡@http://club.excelhome.net/forum-3-1.html¡@¥i¥H§ä¨ì§ó¦h¨Ò¤l¡I¡I¡I

TOP

Áª©¥D¡A¯u¬O¤Ó±j¤j¤F¡A­t¸¹ªº³¯­z¡A·Pı¦³C»y¨¥ªº©w«ß¦b¸Ì­±¡A³o¨ç¼Æ¤½¦¡¡A§Ú¥i¯uªº¼g¤£¥X¨Ó¡C

¥u¦n¼g¥X­Ó©Ç©Çªº¨ç¼Æ¤½¦¡¡A«¢«¢¡C

TOP

B4 À³§ï¬°A1¤~¹ï­ò¡AÁÂÁ¡C

TOP

¦^´_ 5# ¾Ç¨ì¦Ñ¦º


    ¦p­ãª©©Ò¥Ü¡A¤@¯ë¬O¥Î -- §â¼Æ¦r«¬ªº¤å¦r¤Æ¦¨¼Æ¦r
   ±z¶Kªº¡A¬O¦]¬°sum¨ç¼Æ¦]¬°¥iª½±µ§â¼Æ¦r«¬¤å¦r¤Æ¦¨¼Æ¦r­pºâ
   ¤£§«¸Õ¸Õ A1="123"¡A¥Îb1=sum(a1)¡Ab2=sum("123")¡Aª±ª±¬Ý¡A¬Ý¬Ý¦³¤°»ò¤£¤@¼Ë....
   
  c1 = 04/01_AAA¦¬¤J4061.34  ¡A¿ï¨ú c1 > ¶ñº¡>¥ª¥k¹ï»ô¡Aª±¤@¤U¡A«Ü¦³¼Ö½ìªº ^^

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD