255
edits
Excel Data Quality Toolkit: Difference between revisions
→Date is Suspiciously Old
| Line 36: | Line 36: | ||
'''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 date values. | |||
# Under "Order", select "Oldest to Newest" from the dropdown menu. If this option is not available, this means Excel does not recognize your date column as containing dates (which can actually be easier to work with). Select "Smallest to Largest" or "A to Z" instead. | |||
# If you were able to sort from Oldest to Newest, the oldest dates should now be at the top. Review them for dates that seem impossibly old for your collection. If you were not able to sort the column as a date, check both the top and the bottom of the spreadsheet for too-old dates. | |||
=== Identified Date Earlier than Collected Date === | === Identified Date Earlier than Collected Date === | ||