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

for whole sheet

for C column only

Error alert
enter you own error message

No comments: