Hey everyone I am trying to help out a friend who has a list of say 60,000 people. Each row is a person whose info is broken up by columns with names like; name, address, phone, zipcode etc.
The problem is this;
I have been supplied with a list of around 7,000 zipcodes and need to essentially scrub the lead sheets against this and keep only the rows with a zipcode from the 7,000.
I have tried a couple methods I thought may work, like advance filtering but I am not doing it correctly.
Any help would be super appreciated!
Bookmarks