November 12, 2010

Prevent Duplicate Entries in Excel formulae


Problem: Duplicate entries Excel formula is not working

Proposed formula found on google is not working; =COUNTIF($A$1:$A$50,A1)=1

the correct one is this, with ";" instead of ","

Data - Validation
Allow: Custom

=COUNTIF($A$1:$IV$20000;A1)=1
for whole sheet

=COUNTIF($C$1:$C$20000;C1)=1
for C column only

Error alert
enter you own error message

No comments: