Use of Countif Value

We know that Countif formula is of form



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





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



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

 Download and try 

Find Duplicate Values Using Data Validation - Data Validation

Get live Maths 1-on-1 Classs - Class 6 to 12

Ask a doubt
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 13 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.