I have a long list of survey results with zipcodes and would like to additionally organize them by borough.
See NY Borough Zip Code List: http://www.health.ny.gov/statistics/...ghborhoods.htm
I know how to assign words with IF(logic,if true, if false), but do not know how to have the logic be IF(these zipcodes,if true) and IF(these zipcodes,if true).
Please help!
Last edited by inputsandoutputsn00b; 11-02-2011 at 05:01 PM.
Set up a second table showing all zipcodes with the associated boroughs. Then you can use a vlookup to populate the borough for each zip.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks