how to apply unique constraint in excel column

  • Thread starter Thread starter Basit
  • Start date Start date
Hi Tyro,
Unique mean that every value in the specified excel column should be
unique. like we do in the databases.
 
Basit said:
.. Unique mean that every value in the specified excel column should be
unique. like we do in the databases.
Click to expand...

If you mean, to ensure no duplicates in an input col ..

Assume that inputs will be done in A1 down
Select col A, click Data > Validation,
Allow: Custom
Formula: =COUNTIF(A:A,A1)<2
Click OK

---
 
Thanks a lot Max it worked.

Max said:
If you mean, to ensure no duplicates in an input col ..

Assume that inputs will be done in A1 down
Select col A, click Data > Validation,
Allow: Custom
Formula: =COUNTIF(A:A,A1)<2
Click OK

---
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Interface Constraints 6
Unique Constraint 1
How to filter Unique values from Duplicates 6
How to assign unique number to column duplicates? 3
How to avoid duplicate string value input in one column? 1
Excel Trying to code an Array Function in VBA Excel to works as a MaxIF 3
Error "Failed to enable constraints." 1
Goal Seek with two constraints 1

Back
Top