255
edits
Excel Data Quality Toolkit: Difference between revisions
Jump to navigation
Jump to search
→Invalid Individual Count
| Line 142: | Line 142: | ||
'''Solution:''' | '''Solution:''' | ||
# Click the triangle icon just above and to the left of the first cell in your spreadsheet. This should select all the cells in your spreadsheet. | |||
# In the "Editing" section of the Home menu, click Sort & Filter, then Custom Sort. | |||
# Make sure the "My data has headers" box is checked. | |||
# 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. | |||
=== Non-standardized BasisOfRecord Values === | === Non-standardized BasisOfRecord Values === | ||