Enter the formula:
=A1&B1
to cell C1 and copy / paste the formula to cells C2:C12.
Enter the formula:
=IF(COUNTIF($C$1:C1,C1)>1,"Duplicate","Unique")
to cell E1 and copy / paste the formula to cells E2:E12.
Screenshot // Find duplicates items in combine columns in Microsoft Excel
SOURCE | LINK (Exceltip.com) | LANGUAGE | ENGLISH |