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

[µo°Ý] EXCEL VBA¤¤¡A½Ð°Ý¦p¦ó¼g¥X¦³±ø¥ó¦¡ªº¦Û°Ê½s¬y¤ô¸¹?

[µo°Ý] EXCEL VBA¤¤¡A½Ð°Ý¦p¦ó¼g¥X¦³±ø¥ó¦¡ªº¦Û°Ê½s¬y¤ô¸¹?


¦p¹Ï¡A§Æ±æ¥i¥H¦b¿é¤JAÄæ©MBÄ檺¸ê®Æ«á¡A¥H¦P¼Ëªº¶¶§Ç±N¨ä¥H¤À¿¤¥«+°Ï°ì+¬y¤ô¸¹ªº¤è¦¡­«·s½s¸¹¡A¦ý¬y¤ô¸¹¥u¦³¦b´«¿¤¥«(AÄæ)«á¤~·|­«·s¶}©l­pºâ¡C
ÁÂÁÂ^ ^

¦^´_ 1# likevision
¹Ï¤W¬O´«°Ï´N­«½s¬y¤ô¸¹¤F¡A©M§A¤å¦r±Ô­z¤£²Å¡C
°²³]¹Ï¤ù¤W¤~¬O§A­nªº:
³Ì²³æ¤èªk´Nª½±µD2¶ñ¤J¤½¦¡  
= A2 & B2 & TEXT(COUNTIFS(A$2:A2,A2,B$2:B2,B2),"00")
µM«á¦V¤U¶ñº¡¤½¦¡
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD