On the Duplicate sheet, you will be using the Conditional Formatting Duplicate Values

option to identify the differences between the Customer Names and the Product IDs.

$-$ In the Column A and D$,$ use Conditional Formatting Duplicate Values to highlight only

the unique values in Red. Hint: You will need to select both columns to find the unique

values.

$-$ Then, sort the data in column D according to cell color so the red cells go to the top.

$-$ In Columns G and J$,$ do the same procedure to get the duplicate values $($red cells$)$ to the

top of each column $($G and J$).$