83
edits
Excel Data Quality Toolkit: Difference between revisions
Jump to navigation
Jump to search
→Misspelled or Invalid Taxonomic Names
Jegelewicz (talk | contribs) |
Jegelewicz (talk | contribs) |
||
| Line 177: | Line 177: | ||
=VLOOKUP(A1,'taxa'!$A$1:$A$11,1,FALSE) | =VLOOKUP(A1,'taxa'!$A$1:$A$11,1,FALSE) | ||
This same process can be used to solve issues. Get a list of unique values in your scientific name column by copying the entire column to column A in a new tab, highlight the copied data and from the main Excel menu select Data->Remove duplicates. In column B add the correct scientific name that should be used for every term in column A even if the two are the same. | |||
Use a LOOKUP like the one above to get the correct scientific name for every row in your file. | |||
=VLOOKUP(A1,'unique taxa'!$A$1:$B$11,2,FALSE) | |||
Note that the unique values to check are in column A of the unique taxa tab and the correct replacement values are in column B of the unique taxa tab. Also note that the value being returned is from column B indicated as the 2nd column in the array. | |||
=== Unknown Higher Taxonomy === | === Unknown Higher Taxonomy === | ||