shan0948

¦^´_ 10# Andy2483


    ·PÁÂ¥ý¶iªº«ü¾É¡A¦]¤§«e¬O¨Ï¨ç¼Æ¤½¦¡¡A¬G¬°ºû«ù¤@­P©Ê¡A¥i§_¤´¨Ï¥Î¨ç¼Æ¤½¦¡³]©w¡AÁÂÁ¡I

Andy2483

¦^´_ 11# shan0948


    ÁÂÁ«e½ú¦^´_
¤½¦¡(¨ç¼Æ)¤ñVBAÃø,«á¾Ç¼ÈÀ°¤£¤W¦£

ML089

¦^´_ 9# shan0948

20230314 ©m¦W«ö°_¤î¤é´Á±Æ¦C-§ó·s ªº½Æ¥».rar (18.39 KB)

¤U¸ü¦¸¼Æ: 3

2023-3-14 15:26

¤½¦¡L4=SUBSTITUTE(TRIM(IF($H4=L$3,$F4,"")&IF($A5=""," "&L5,""))," ","¡B") ¥k©Ô¤U©Ô
¤½¦¡N4=SUBSTITUTE(TRIM(IF(ISERROR(FIND($G4,N$3)),"",$F4)&IF($A5=""," "&N5,""))," ","¡B") ¥k©Ô¤U©Ô

±ø¥ó¦¡®æ¦¡³]©w
¿ï¾Ü L4:O50
¤u¨ã¦C - ±ø¥ó¦¡®æ¦¡³]©w - ·s¼W³W«h - ¨Ï¥Î¤½¦¡¨Ó¨M©w... - ¤½¦¡ = $A4=""
±N¶ñº¡»P¦r«¬ªºÃC¦â ³]¬°­I´ºÃC¦â(¥Õ¦â)

shan0948

¦^´_ 13# ML089


    M ¤j¦n¡A·PÁ«ü¾É¡A¸g´ú¸Õ¤½¦¡³]©w«áµ²ªG¦ü¥¼§¹¥þ²Å¦X¼W¥[ªº»Ý¨D¡A¸Ô²Ó»¡©ú¦pªþÀɮסAÁÂÁ¡I ©m¦W«ö°_¤î¤é´Á±Æ¦C-§ó·s.zip (20.61 KB)

¤U¸ü¦¸¼Æ: 2

2023-3-15 07:49

ML089

¦^´_ 14# shan0948
°ÝÃD¡G
¤é´Á 1 °_¡G
±çÂí¾|¡B¸­º~³¹ 2¤H¶ÈÅã¥Ü¦b L4 ¡A
L5¡BL6¡BL7¡BL8¡BL9 §¡¤£Åã¥Ü¡A
¤é´Á 1 ¤î ¤]¬O¦P¼Ë¤è¦¡

¦^ÂСG
(1) ¦³¤é´Á¦ì¸m L4¡A¤½¦¡µ²ªG¬O§_²Å¦X§A­nªºµª®× ?
(2) L5¡BL6¡BL7¡BL8¡BL9 §¡¤£Åã¥Ü¡A¥i¥H¨Ï¥Î ¥Õ¦â¤å¦r¤Î¶ñ¥R¥Õ¦â¨Ó¾B»\¤å¦r¡A³]©w¤W¦¸¤w¸g»¡©ú¡A¦p¤U
±ø¥ó¦¡®æ¦¡³]©w
¿ï¾Ü L4:O50
¤u¨ã¦C - ±ø¥ó¦¡®æ¦¡³]©w - ·s¼W³W«h - ¨Ï¥Î¤½¦¡¨Ó¨M©w... - ¤½¦¡ = $A4=""
±N¶ñº¡»P¦r«¬ªºÃC¦â ³]¬°­I´ºÃC¦â(¥Õ¦â)

shan0948

¦^´_ 15# ML089


    M ¤j¦n¡A·PÁ±zªº¦^ÂСA±zªº¤½¦¡¦³±o¨ì»Ý­nªºµ²ªG¡A¤]ÁA¸Ñ±zªº·N«ä¡A³o¤è¦¡¤]¤£¥¢¬°¥t¤@ºØ³~®|¡AÁÂÁ±z¡I