Formula to Check for Duplicates Records in Excel

Below is the formulae you can use to check value is duplicate or not


=IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2,C$2:C2,C2,D$2:D2,D2,E$2:E2,E2)>1,"Duplicate Value","Not Duplicate")

Using it you highlight duplicate value with  color except first one.

Comments

Post a Comment

Popular posts from this blog

Integration Control

Integration control used in making conditions for processing  provides a way to match xml field or object field with particular value. We have 4 types of integration control 1. Value 2.List 3. XRef 4.Boolean Value control is used to compare with single value. List control is used to compare with list of values which may come from domains. Boolean control is true or false value used to compare yorn field I personally never used it. XRef control i.e cross reference control is used to to swap values foe example we have different orgid in other system than we can define cross reference control inorder to translate. We create cross reference control and associate it with enterprise service or publish channel. We can also override these values at external system level.
Read more

Zensar Java interview questions

1. Difference between abstract and interface. 2. Difference between result in case of put a s post if everything is same. 3. Java 8 features ? 4. What's is need for default method in Java 8 in interface? 5. Jdbc template and callable statement use? 6. How u loop in stored procedure write a programme. 7. Comparator programme? 8. Why string is immutable? 9. What is difference between a+b and a+=b?
Read more