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

This workshop is not currently scheduled. Please contact us to schedule a session for you.


Preview the Slides

Watch Overview Video

Additional Information

View Related Workshops In

Hosted By

If you have any questions regarding this workshop or would like to see this workshop offered please contact

DoIT Training and Development