Check sibling questions

Find Duplicate Values Using Data Validation

Last updated at May 29, 2018 by

Use of Countif Value

We know that Countif formula is of form

=COUNTIF(RANGE,CRITERIA)

 

This formula can also be used to find duplicate value

=countif(RAnge,SELECT ONE CELL)

If there are unique values (no duplicate) ,it will show 1

if there are 2 values,it wil show 2

if there are 3 values,it wil show 3

Example

 

 

 

Here,in custom field,we can put following COUNTIF Formula

COUNTIF(Select Range, Select Range in Criteria)=1

Note:-While selecting range ,we have to press F4

 

Q6

Prepare Data Validation on column so that no duplicate Bill No entered in columns

 Download and try 

DATA VALIDATION ASSIGNMENT.xlsx

Find Duplicate Values Using Data Validation - Data Validation

 
 
 
 
Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.