# Duplicate Value comparing 2 Columns

#### TWINKLEMARVEL

##### Board Regular
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.

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
something like...

Excel 2012
ABC
1Installation123456unique
2Warranty111111unique
3Installation123456duplicate
4Installation654654unique
5AMC582369unique
6Warranty111111duplicate
7OG789654unique
8AMC154689unique
9OG123123unique

</tbody>
Sheet3

Worksheet Formulas
CellFormula
C1=IF(COUNTIFS(\$A\$1:A1,A1,\$B\$1:B1,B1)>1,"duplicate","unique")

</tbody>

<tbody>
</tbody>

Weazel
Perfect. This is what I was expecting.

Thanks a lot.

something like...

Excel 2012
ABC
1Installation123456unique
2Warranty111111unique
3Installation123456duplicate
4Installation654654unique
5AMC582369unique
6Warranty111111duplicate
7OG789654unique
8AMC154689unique
9OG123123unique

<tbody>
</tbody>
Sheet3

Worksheet Formulas
CellFormula
C1=IF(COUNTIFS(\$A\$1:A1,A1,\$B\$1:B1,B1)>1,"duplicate","unique")

<tbody>
</tbody>

<tbody>
</tbody>

Replies
12
Views
828
Replies
7
Views
227
Replies
6
Views
618
Replies
11
Views
1K
Replies
2
Views
963

1,221,213
Messages
6,158,565
Members
451,498
Latest member
tyshanklin1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back