how to apply unique constraint in excel column
 

how to apply unique constraint in excel column

how to apply unique constraint in excel column
 

What is a unique constraint?

Tyro

"Basit" wrote in message
...
how to apply unique constraint in excel column

how to apply unique constraint in excel column
 

Hi Tyro,
Unique mean that every value in the specified excel column should be
unique. like we do in the databases.

"Tyro" wrote:

What is a unique constraint?

Tyro

"Basit" wrote in message
...
how to apply unique constraint in excel column

how to apply unique constraint in excel column
 

"Basit" wrote:
.. 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

how to apply unique constraint in excel column
 

Thanks a lot Max it worked.

"Max" wrote:

"Basit" wrote:
.. 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

how to apply unique constraint in excel column
 

Welcome, glad to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Basit" wrote in message
...
Thanks a lot Max it worked.