Finding Duplicates in Google Sheets

Audience: Clubs, Faculty, Guests, Postdocs, Researchers, Staff, Students and Teaching Assistants

Workshop Level: Intermediate

At The End Of This Workshop You Will Be Able To

Find duplicates several ways, including using


Sort your data by the column you're looking for duplicates in to better see duplicates.


Filter data by condition using a custom formula to show only the duplicate values in a column.

Conditional Formatting

Apply conditional formatting to highlight duplicate values in a column or row.

Current Workshop Schedule

For a complete list of our current workshop offerings please visit our events calendar.

View Events Calendar


Preview the Slides

Watch Overview Video

Additional Information

View Related Workshops In

Hosted By

DoIT Training and Development