How to highlight duplicates in a list

In this lesson we’ll look at one way to approach this problem.

Let’s take a look.

That is, rows that contain all of the same values.

Let’s call this column “Key,” as in “unique key.”

Now let’s add the formula.

This is called “concatenation.”

Now that we have this value, we can apply the conditional formatting preset for duplicates.

This time, only true row duplicates are highlighted.

When you’re done with the key, simply remove the column from the table.