Conditional Formatting can identify duplicate values. When you highlight a list and click Conditional Formatting, pick Highlight Cell Rules and specify Duplicate Values. The dupes will be highlighted.

Name:  Translate words, even sentences.jpg
Views: 28
Size:  20.6 KB