Delete all Duplicates including itself

Delete all Duplicates including itself

17
Basic UserBasic User
17

    Jun 26, 2006#1

    Hello,

    I want to remove all duplicate entries from a file including itself, so there are no lines left with that name.

    Example:

    Before.

    Code: Select all

    113F
26566Fzu
113F
523FD798
ADF465EW
113F
    After.

    Code: Select all

    26566Fzu
523FD798
ADF465EW
    I tried the Sort function but it leaves one line with the same name.

    How can I do that?
    6,675585
    Grand MasterGrand Master
    6,675585

      Jun 26, 2006#2

      Hi!

      I think you already know my macro at How do I remove duplicate lines?, aren't you.

      You only have to replace the command CopyAppend by CutAppend and you will get a file where all duplicates are deleted completely and the report contains the deleted lines.
      Best regards from an UC/UE/UES for Windows user from Austria
      17
      Basic UserBasic User
      17

        Jun 26, 2006#3

        Yes, I do know your macro and thanks again for your help.