See the screenshot below for the formula and the results. Let’s use the UNIQUE function in one more example. This time the dataset we have been using has the first and last names in different columns.