Home |
Search |
Today's Posts |
#1
|
|||
|
|||
set up a column in excel with unique entries
How does one create a column to accept only unique serial numbers. The
serial number will contain text if that matters. Thanks in advance, |
#2
|
|||
|
|||
Hi!
Use Data Validation. Select the range in question. Assume that range is A1:A10. Goto DataValidation From the Allow list select Custom In the Formula box enter: =COUNTIF(A$1:A$10,A1)=1 OK out. Biff -----Original Message----- How does one create a column to accept only unique serial numbers. The serial number will contain text if that matters. Thanks in advance, . |
#3
|
|||
|
|||
Using Validation is one way. See Debra D.'s site for
instructions: http://www.contextures.com/xlDataVal07.html#Unique HTH Jason Atlanta, GA -----Original Message----- How does one create a column to accept only unique serial numbers. The serial number will contain text if that matters. Thanks in advance, . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Despite formatting a column in Excel 2002 worksheet as Short Date. | Excel Discussion (Misc queries) | |||
How to sort/update large excel db | Excel Discussion (Misc queries) | |||
Finding Unique Values in Column | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
Excel - option to extend function in cell to column | Excel Worksheet Functions |