This project includes a database of all cities in the united states. I need to take the database and have it cleaned up. I need to only show unique entries when compared with two separate columns. When these two columns are the same then I need to only have that unique entry and delete all the others. For instance many states have cities with the same name. For instance there would be a "city A" in maryland and washington state. I want to keep both of them. But if there are multiple zip codes for "city A" in washington state then I want only one entry to appear it doesn't matter which one.
I don't have the know how but anyone with basic excel knowledge could pull this one off with just some filtering.