| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keep all cells in a column unique? No cells identical
Hello. I'm creating a video catalogue list. Each video is being assigned a
unique ID number. Column A is my ID # column. Is it possible to keep every cell in Column A unique? If so, what would Excel do if I inputted two identical cell values? I'm using Excel 2002. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Keep all cells in a column unique? No cells identical
Click on A1 and:
Data Validation Settings Custom Formula =COUNTIF(A:A,A1)<2 Then copy A1 down as far as you need -- Gary''s Student - gsnu200801 "phillr" wrote: Hello. I'm creating a video catalogue list. Each video is being assigned a unique ID number. Column A is my ID # column. Is it possible to keep every cell in Column A unique? If so, what would Excel do if I inputted two identical cell values? I'm using Excel 2002. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula that would highlight two identical cells.. | Excel Discussion (Misc queries) | |||
| how do i shade all identical cells automatically | Excel Worksheet Functions | |||
| Finding and Highlighting Similar but not Identical Cells in a Colu | Excel Discussion (Misc queries) | |||
| Protection of identical cells on multiple worksheets | Excel Worksheet Functions | |||
| TRYING TO SORT, MERGED CELLS HAVE TO BE IDENTICAL? | Excel Discussion (Misc queries) | |||
Linear Mode
