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:
Post a Comment