First time poster. I have a very large data set (.5 GB) to dig through. Any recommendation on a screening technique to remove any zip codes that don't match my target? The catch: I'm on a Mac (so no VBA) and there are approx. 90+ zip codes.
I've attached an initial draft of the document. The desired zip codes are in column L. Any help is appreciated. Thanks.
Hello & Welcome to the Board,
With the desired zip codes in column L and matching against the zip codes in column B, use a helped column to find the match and then filter by that helped column for a non-number and delete
Example, column M >> =MATCH(B2,$L$3:$L$80,0)
If there is a match this formula will return a number, if not, then #N/A
Filter by the #N/A and delete visible rows
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks