Delete all Duplicates including itself

[HansFink]

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?

[Mofi]

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.

[HansFink]

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