![]() ![]() This would highlight the duplicate values in column E. In the Duplicate Values dialog box, make sure Duplicate is selected and then specify the color in which you want to highlight the duplicate values.Select the range that has the combined strings (E2:E16 in this example).Here are the steps to highlight duplicate strings: A highlighted string implies that the row has a duplicate. Now that we have the combined strings for each row, we can use conditional formatting to highlight duplicate strings. If there are duplicate rows in this dataset, then these strings would be exactly the same for it. ![]() (You can also use the CONCATENATE function to combine text strings)īy doing this, we have created a single string for each row. This formula combines all the cell values as a single string. In an adjacent column, use the following formula:ĭrag this down for all the rows.Have a look:įinding duplicate rows is a bit more complex than finding duplicate cells. ![]()
0 Comments
Leave a Reply. |