255
edits
Excel Data Quality Toolkit: Difference between revisions
→Invalid Individual Count
| Line 147: | Line 147: | ||
# In the Sort By row under "Column", select the column/field that contains your individualCount values. | # In the Sort By row under "Column", select the column/field that contains your individualCount values. | ||
# Keep the value "Cell Values" under "Sort On", then under "Order", select the "Largest to Smallest" option. This will bring all the non-numeric values in this field to the top of your spreadsheet, and you can review and fix them as necessary. | # Keep the value "Cell Values" under "Sort On", then under "Order", select the "Largest to Smallest" option. This will bring all the non-numeric values in this field to the top of your spreadsheet, and you can review and fix them as necessary. | ||
# Try again with the "Smallest to Largest" option under Order to find any erroneous negative values. | |||
=== Non-standardized BasisOfRecord Values === | === Non-standardized BasisOfRecord Values === | ||