how to apply unique constraint in excel column
B Basit Mar 12, 2008 #3 Hi Tyro, Unique mean that every value in the specified excel column should be unique. like we do in the databases.
Hi Tyro, Unique mean that every value in the specified excel column should be unique. like we do in the databases.
M Max Mar 13, 2008 #4 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
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
B Basit Mar 13, 2008 #5 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...
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...
