16
edits
Excel Data Quality Toolkit: Difference between revisions
Jump to navigation
Jump to search
→Elevation is Unlikely
| Line 85: | Line 85: | ||
# From the Data toolbar, click "Filter". | # From the Data toolbar, click "Filter". | ||
# Navigate to the column containing your elevation values (e.g. dwc:[https://dwc.tdwg.org/terms/#dwc:minimumElevationInMeters minimumElevationInMeters], dwc:[https://dwc.tdwg.org/terms/#dwc:maximumElevationInMeters maximumElevationInMeters]) and select the arrow icon next to the column header indicating that this column can now be filtered on. | # Navigate to the column containing your elevation values (e.g. dwc:[https://dwc.tdwg.org/terms/#dwc:minimumElevationInMeters minimumElevationInMeters], dwc:[https://dwc.tdwg.org/terms/#dwc:maximumElevationInMeters maximumElevationInMeters]) 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 "Between", set "Less Than" = "0" and "Greater Than" = "17000", and select "Apply Filter" | # At the bottom of the pop-up window, change the filter criterion "Choose One" to "Between", set "Less Than" = "0" and "Greater Than" = "-17000", and select "Apply Filter". | ||
=== Improperly Negated Latitudes/Longitudes === | === Improperly Negated Latitudes/Longitudes === | ||