Duplicate Value comparing 2 Columns

[TWINKLEMARVEL]

Dear Experts,

Can anyone help me in finding the duplicate value by comparing 2 columns.

Eg:

Column A	Column B
Installation	123456
Warranty	111111
Installation	123456
Installation	654654
AMC	582369
Warranty	111111
OG	789654
AMC	154689
OG	123123

<tbody>
</tbody>

Need a formula in Column C Such that it compares,

Installation With Same Serial No,
Warranty with Same Serial No,
AMC with same Serial.No
OG with same Serial No
etc... like above.

 

[Weazel]

something like...

Excel 2012

	A	B	C
1	Installation	123456	unique
2	Warranty	111111	unique
3	Installation	123456	duplicate
4	Installation	654654	unique
5	AMC	582369	unique
6	Warranty	111111	duplicate
7	OG	789654	unique
8	AMC	154689	unique
9	OG	123123	unique

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet3​

Worksheet Formulas Cell Formula C1 =IF(COUNTIFS($A$1:A1,A1,$B$1:B1,B1)>1,"duplicate","unique") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[TWINKLEMARVEL]

Weazel Perfect. This is what I was expecting.

Thanks a lot.

something like...

Excel 2012

	A	B	C
1	Installation	123456	unique
2	Warranty	111111	unique
3	Installation	123456	duplicate
4	Installation	654654	unique
5	AMC	582369	unique
6	Warranty	111111	duplicate
7	OG	789654	unique
8	AMC	154689	unique
9	OG	123123	unique

<tbody>
</tbody>

Sheet3​

Worksheet Formulas Cell Formula C1 =IF(COUNTIFS($A$1:A1,A1,$B$1:B1,B1)>1,"duplicate","unique") <tbody> </tbody>

<tbody>
</tbody>