There are three simple approaches to dealing with duplicates in Excel. One of which will extract only the unique values from a list with potential duplicates. The second, return true if a value appears more than once, and a quick conditional formatting rule to highlight all duplicates.