Using Excel with maps

[mickirogers]

Hello, I am newer to more advanced Excel topics. I have a set of 8000 or so locations (each includes street address, city, state, county, latitude, and longitude). I have been tasked with finding out how many of these locations are between the Mississippi River and the Rocky Mountains. Anyone familiar with doing this sort of thing?

Thanks!

 

[cyrilbrd]

maybe you could map the longitude and latitude (north and south) and see what fits in it?