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.
=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