B
Basit
how to apply unique constraint in excel column
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tyro
What is a unique constraint?
Tyro
Tyro
B
Basit
Hi Tyro,
Unique mean that every value in the specified excel column should be
unique. like we do in the databases.
Unique mean that every value in the specified excel column should be
unique. like we do in the databases.
M
Max
Basit said:.. Unique mean that every value in the specified excel column should be
unique. like we do in the databases.
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
---
B
Basit
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
---
M
Max
Welcome, glad to hear that.