Excel Data Quality Toolkit: Difference between revisions

Excel Data Quality Toolkit (view source)

127 bytes added , 29 March

83

edits

@@ Line 109: / Line 109: @@
 '''Problem:''' Lower geography (e.g., county, state/province) values exist, but no higher geography values (e.g., country) are provided.
-'''Solution:'''
+'''Solution:''' Check for missing higher levels of geography with this formula where A1 is the country, B1 is the state, 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")))