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

[µo°Ý] Excel2003 remove duplicates¬Û®e©Ê°ÝÃD

°ò¥»¬[ºc:
1) AH1 ©ñ¸ê®ÆÅÜ°ÊÀË´ú¤½¦¡, ­Y¦³ÅÜ°Ê, «h¥[¤@µ§·s°O¿ý,     
    ¨Ò¥~:B2:AG2¦³[¿ù»~­È]®É, ©Î B2 «D¼Æ­È(¨S¦³®É¶¡­È), «h¤£°O¿ý~~
2) ¦bB3:AG3¦P®É¦s©ñ³oµ§°O¿ý, ¨Ñ¤U¦¸¤ñ¹ï¬O§_ÅÜ°Ê
3) A3²Ö­pµ§¼Æ, ¦P®É°O¿ý¨ìMAINªí¬Û¹ïÀ³Àx¦s®æ

³o»ò¦hªí¦P®ÉIJµoµ{¦¡, ·|¤£·|¥´¬[.²£¥Í¿ù»~.©Îº|°O¿ý, ¤£±o¦Óª¾,
¦Û¦æ¥h´ú, ¨Ã¨Ì¹ê»Ú¹B¥Î¥h¦Û¦æ­×§ï¤½¦¡©Îµ{¦¡, ¯àÀ°ªº´N³o¼Ë:
DDE_main_01.rar (40.1 KB)

TOP

Sheets(1).Cells(Me.Index + 1, 2) = [A3]
§ï¦¨¥H¤U¤~¹ï:
Sheets(1).Cells(Me.Index, 2) = [A3]

TOP

¦^´_ 11# ­ã´£³¡ªL


    ÁÂÁ­ã¤j¡I «D±`·PÁ±zµL¨pªºÀ°§U §Ú¥»¨Ó¥¿¦b¹Á¸Õ¥Î±zºô¯¸ªº´£¨Ñªºµ{¦¡¨Ó­×§ï

µ²ªG´N¦³·sªº¦^ÂФF¡I §Ú¨Ó¸Õ¸Õ¬Ý¹ê»Ú¶]°_¨Ó¯à¤£¯à¦¨¥\!

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD