Quick Guide to using herbarium data in Excel

Activity 3: Mailing List – Find and Remove Duplicates. Create a new column to combine first name and last name together (concatenate or flash fill) Create a table. Use conditional formatting to find duplicates. Sort column A-Z. Filter by color. Look closely at duplicates. Remove duplicates based off of first name last name column, email, and ... ................
................