Hello,
So I am having some spreadsheet issues, using excel. So I'll get right to it.
I am keeping population count data of every county in the USA.
However, I do not have population data for Puerto Rico.
I would like to take my spreadsheet of every USA county, and delete all counties/municipalities that belong to Puerto Rico, or any other U.S territories outside of the 50 states.
How can I do this?
Is there some way to take my spreadsheet that has info for only 50 states counties, select them, then go to the spreadsheet that has info for all 50 states counties, plus territories, and tell excel, hey, delete all rows that don't match the entries of my other spreadsheet?
Thanks!
Try to use Pivot Table. Youtube and the Internet can explain to you how to use it. It depends on the version of Excel you are using. Good luck
A filter on the page with non-US data would be easiest. Unselect those variables.
If you need to integrate, use vlookup.
- Badges
- Science topic