How to remove duplicates after collecting a huge list of names?

How to remove duplicates after collecting a huge list of names?

In excel on the website it is difficult, because at 400,000 it stutters.

However, in the program, when I take to remove duplicates, everything is sorted and mixed right away and I do not have these new names separated from the old ones, but mixed together.

What to do? Step by step like a sick person.

Use the built-in tools in just about every spreadsheet software to highlight the duplicates. WPS should do it and its a free suite.

Put all of these names into array, then filter them to just keep uniques. Try javascript lodash and method „uniq” for that.

Here's a PHP script sample :

https://www.tehplayground.com/U22NlTTciMe82lPw