83
edits
Excel Data Quality Toolkit: Difference between revisions
→Lower Geography Values are Provided, but No Higher Geography
Jegelewicz (talk | contribs) |
Jegelewicz (talk | contribs) |
||
| Line 109: | Line 109: | ||
'''Problem:''' Lower geography (e.g., county, state/province) values exist, but no higher geography values (e.g., country) are provided. | '''Problem:''' Lower geography (e.g., county, state/province) values exist, but no higher geography values (e.g., country) are provided. | ||
'''Solution:''' Check for missing higher levels of geography with this formula where A1 is the country, B1 is the | '''Solution:''' Check for missing higher levels of geography with this formula where A1 is the country, B1 is the stateProvince, and C1 is the county. | ||
=IF(ISBLANK(C1),IF(ISBLANK(B1),IF(ISBLANK(A1),"no geography","OK"),IF(ISBLANK(A1),"missing country","OK")),IF(ISBLANK(B1),IF(ISBLANK(A1),"missing state and country","missing state"),IF(ISBLANK(A1),"no country","OK"))) | =IF(ISBLANK(C1),IF(ISBLANK(B1),IF(ISBLANK(A1),"no geography","OK"),IF(ISBLANK(A1),"missing country","OK")),IF(ISBLANK(B1),IF(ISBLANK(A1),"missing state and country","missing state"),IF(ISBLANK(A1),"no country","OK"))) | ||
country !! stateProvince !! county !! check | |||
|- | |||
| || Texas || Kerr|| no country | |||
|- | |||
| USA || || Kerr|| missing state | |||
|- | |||
| || Texas || || missing country | |||
|- | |||
| USA || || || OK | |||
|- | |||
| || || Kerr || missing state and country | |||
=== Minimum and Maximum Elevation Values Mismatched === | === Minimum and Maximum Elevation Values Mismatched === | ||