Interview Questions

Wednesday, April 16, 2014

How to find Duplicate values in given Columns in MS EXCEL

Write this formula in a new cell: 
=IF(SUMPRODUCT(($A$2:$A$10=A2)*1,($B$2:$B$10=B2)*1,($C$2:$C$10=C2)*1)>1,"Duplicates","No duplicates"),

Here, we are using Column A (Range = A2:A10) same for B column and C column. If you have more columns then add same block of code for those columns and vise versa.

No comments:

Post a Comment