83
edits
Excel Data Quality Toolkit: Difference between revisions
→Non-standardized BasisOfRecord Values
Jegelewicz (talk | contribs) |
Jegelewicz (talk | contribs) |
||
| Line 210: | Line 210: | ||
Note that even punctuation and capitalization differences in these values (e.g., Preserved Specimen) are discouraged. | Note that even punctuation and capitalization differences in these values (e.g., Preserved Specimen) are discouraged. | ||
'''Solution:''' | '''Solution:''' Avoid this issue with a pick list as data are entered. For a tutorial see [https://support.microsoft.com/en-us/office/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b Create a drop-down list] | ||