CODEWITHSUNDEEP
exceloffice-2013
Abhishek Kumar
Abhishek Kumar

Reputation: 352

COUNTIF() in Excel (Office 2013)

Dear All I want to Eliminate the possibility of entering a Duplicate item in a range. I used =COUNTIF($C$3:$C$151,C3)<=1 in Excel (office 2013) in Custom Data Validation. Below is the Error I get. I am not able to figure it out. Please give your input. enter image description here

Upvotes: 0

Views: 134

Answers (2)

Andrey Gurenkov
Andrey Gurenkov

Reputation: 68

Try this:

=COUNTIF( $C$3:$C$151; C3 ) <= 1

Upvotes: 1

Doug Coats
Doug Coats

Reputation: 7107

 =countif(range, criteria)

 =countif($C$1:$C$151, "<=1")   'better formula

Upvotes: 1

Related Questions