This record duplicates the first name, Susan, but not the last name. Notice that the worksheet has a new record (row 6).
Next, in cell E2 enter the following formula and copy it to accommodate the remaining list: Copy the formula to accommodate the remaining list items. You could insert a space character between the two names if you liked, but it isn’t necessary. For example, if you wanted to find duplicates of both first and last names in the example worksheet, you’d enter the following formula in cell D2 to concatenate the first and last name values: To find duplicates across multiple columns, use two expressions: One to concatenate the columns you’re comparing a second to count the duplicates. The conditional format works great for a single column. If you want Excel to highlight only the copies, leaving the first occurrence of the value unaltered, enter the formula =COUNTIF($A$2:$A2, A2)>1 in step 4. The conditional format will highlight any value in column A that’s repeated.