| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to apply unique constraint in excel column
how to apply unique constraint in excel column
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the size constraint of the Excel 2007 solver? | Excel Discussion (Misc queries) | |||
| In excel, how do I enter unique cell information in a column | Excel Worksheet Functions | |||
| Unique data in column or row in Excel | Excel Discussion (Misc queries) | |||
| how to make number unique in Excel column? | New Users to Excel | |||
| set up a column in excel with unique entries | Excel Discussion (Misc queries) | |||
Linear Mode
