Forum Discussion
Excel Geography fails to recognize state county... Denver County, Colorado ...
Could you please to give bit more details what exactly you do. Lot of options for Denver and you may force any of it
Certainly, I have a spreadsheet I am using with data sets for 28 states including enrollment information by county in these states. The only state where this is occurring is in Colorado. Below is the entire subset of counties in CO which the system correctly identified. While Bloomfield and Denver are cities and counties I tested other states such as Texas where Dallas is a city and county and it correctly displayed Dallas county, I will show that below as well. I am unable to accurately use the MAP function since it will not recognize Denver County or Broomfield County; therefore they will not display.
County State Organization Name Organization Type Enrolled Adams County, Colorado Colorado Health and Life Local CCP 503 Arapahoe County, Colorado Colorado Health and Life Local CCP 558 Boulder County, Colorado Colorado Health and Life Local CCP 207 Clear Creek County, Colorado Colorado Health and Life Local CCP 15 Delta County, Colorado Colorado Health and Life Local CCP 16 Denver Colorado Health and Life Local CCP 544 Douglas County, Colorado Colorado Health and Life Local CCP 163 El Paso County, Colorado Colorado Health and Life Local CCP 520 Fremont County, Colorado Colorado Health and Life Local CCP 50 Jefferson County, Colorado Colorado Health and Life Local CCP 473 La Plata County, Colorado Colorado Health and Life Local CCP 26 Larimer County, Colorado Colorado Health and Life Local CCP 417 Mesa County, Colorado Colorado Health and Life Local CCP 57 Montezuma County, Colorado Colorado Health and Life Local CCP 94 Pueblo County, Colorado Colorado Health and Life Local CCP 162 Teller County, Colorado Colorado Health and Life Local CCP 35 Weld County, Colorado Colorado Health and Life Local CCP 569 Broomfield, Colorado Colorado Health and Life Local CCP 51 Texas below:
County State Organization Name Organization Type Enrolled Angelina County, Texas Texas Health and Life Local CCP 215 Aransas County, Texas Texas Health and Life Local CCP 12 Atascosa County, Texas Texas Health and Life Local CCP 11 Bandera County, Texas Texas Health and Life Local CCP 12 Bexar County, Texas Texas Health and Life Local CCP 208 Brazoria County, Texas Texas Health and Life Local CCP 242 Cameron County, Texas Texas Health and Life Local CCP 272 Collin County, Texas Texas Health and Life Local CCP 151 Dallas County, Texas Texas Health and Life Local CCP 431 Denton County, Texas Texas Health and Life Local CCP 244 If to play a bit with columns and names they are shown both
Please check in attached file
- I am sorry, I dont know what you mean by "play a bit with columns and names" I have tried doing that and without the geography accurately applying Denver County, Colorado it does not map and will not show the results i need from last column. I am also seeing the same thing in other states where a county is also a city.. This seems to be an issue between Bing and the Geomapping in excel and its quite an issue for us.
Can you further explain what you mean by playing with columns? I can even try selecting from the Data section Denver Colorado and it still fails to map correctly. I was able to create the map you showed above except it does not propagate the data from the column correctly. I appreciate your help with this but this seems like a bigger issue than playing with columns.
