The UNIQUE function in Excel 365 is designed to extract distinct values from a given range of data.

Excel has a built-in conditional rule that highlights unique values. You don’t have to come up with a special formula—you just run though a few clicks. The hardest part is finding it!