Can you help me sort my data to identify all zips/ZCTAs in a city, county or state?
These instructions are optimized for Excel but function much the same in other spreadsheet programs like LibreOffice Calc and Google Sheets.
Sorting the list by Value
Click on the arrow next to the field you want to sort, and click on "Sort Smallest to Largest" or Sort Largest to Smallest".
Finding all Zip/ZCTAs in a state
Click on the arrow next to state
Either select/deselect the checkboxes next to the states…
…or type a state in the search box
Finding all Zip/ZCTAs in a city or county
You can first narrow down the results by filtering first if you know which state your city or county is in.
Then, click on the arrow next to the City or County and type the name of the geography you want to search for.
In some cases, you may get geographies with the same name, but are located in different parts of a state. You can further refine your search results using the County field.
Other Filtering Options
Please see the video below for additional help on:
- Filtering by city/county
- Filtering for high income zips
- Excluding high margin of errors
- Only displaying data for a subset of zip's/ZCTA's using a VLOOKUP