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

[µo°Ý] ­pºâ©³¦â¨Ã¨Ì©³¦â³]©w±ø¥ó

[µo°Ý] ­pºâ©³¦â¨Ã¨Ì©³¦â³]©w±ø¥ó

³Ìªñ¤u§@»Ý­n¨Ï¥Î¨ì¤@¨Çªí®æ,¦ýı±o­ì¥ý¤H­û¯d¤U¨Óªºªí®æ«D±`Ãø¨Ï¥Î
¦Ó¥B±`º|KEY¸ê®Æ,©Ò¥H¸ß°Ý¦U¦ì¤j¯«¬Ý¦³¨S¦³¿ìªk¼g¥X©Ò»Ýªºªí®æ
¦Û¤v­ì¥ý¤]¬ã¨s¤F«Ü¦h¤èªk,¨Ò¦p»Ý­n©w¸q¦WºÙÁÙ¬O¨Ï¥Î§»©ÎVBA...
¦ý¤½¥q¹q¸£¤£¤¹³\(¤Ó¯}Äê..)©Ò¥H¥u¯à¥H¼g¨ç¼Æªº¤èªk
¤£ª¾¹D¯à¤£¯à³æ¯Â¥H¨ç¼Æ¼g¥X©Ò»Ýªº,ÁÙ¬O¥u¯à¥H§»©ÎVBA¨Ó»s§@©O?

»Ý¨D¡G
¥HÀɮ׬°¨Ò
­ì¥ý³£¬O¥þ³¡ªÅ¥Õªº³¡¤À(²Î­p¦Ò¨úªºª¬ªp)
1.°²³]¾î4¬°¦Ò¨úª¬ºA,·|±NA4¼Ð°O¬°ÂŦâ,«hB(N4)·|¦Û°Ê§ì¨ú(H4,I4,J4,K4,L4,M4)³Ì«á¤@µ§ªº¤º®e,¥Hªí®æ¬°¨Ò,BÀ³¸Ó¦Û°Ê¶ñ¬°10807    (C«h¬°10903)
2.S4«h¬°¡÷A4¬°ÂŦâ«á,S4¦Û°Ê²Î­pA:A¦³´X­Ó¬°ÂŦ⪺®æ¤l,¥HÀɮ׬°¨ÒAÀ³¸Ó¬°2

¬d¸ß.rar (7.34 KB)

²q=COUNTIF(N:N,"<>")-1
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD