Excel Data Quality Toolkit: Difference between revisions
Jump to navigation
Jump to search
| Line 59: | Line 59: | ||
'''Solution:''' | '''Solution:''' | ||
Records with zeroed coordinate values can be identified using a filter. | |||
# Open your dataset in Excel and highlight Row 1. | |||
# From the Data toolbar, click "Filter". | |||
# Navigate to the column containing your latitude values (e.g. dwc:[https://dwc.tdwg.org/terms/#dwc:decimalLatitude decimalLatitude]) and select the arrow icon next to the column header indicating that this column can now be filtered on. | |||
# At the bottom of the pop-up window, change the filter criterion "Choose One" to "Equals", enter "0" in the box to the right, and select "Apply Filter". | |||
# If desired, steps 3-4 can be repeated on the column containing your longitude values (e.g. dwc:[https://dwc.tdwg.org/terms/#dwc:decimalLongitude decimalLongitude]). | |||
# Proceed to add geodetic datum values as appropriate where missing. | |||
=== Coordinates Do Not Fall Within Named Geographic Unit === | === Coordinates Do Not Fall Within Named Geographic Unit === | ||