Clean Excel List of URLS

I have an excel list of about 20,000 urls which needs cleaned up so that it only contains 1 unique url. Example: [login to view URL] [[login to view URL]][1] [[login to view URL]][2] I want you to remove all but 1 unique url and it doesn't matter which one you keep. In the example above you could delete all links to this one website except 1: [[login to view URL]][1] This project needs to be completed as soon as possible today. ## Deliverables 1) List should be a clean list with only 1 random url per website when finished. ## Platform microsoft excel