Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
preventing duplicate enrties in a column
How do I make a rule that an identical number cannot be entered twice in an
Excell column? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
preventing duplicate enrties in a column
Mark,
Say in a very deep voice: "Thou shalt not enter the same number twice in one column." ;-) Actually, use Data / Validation, with a custom formula of =COUNTIF(A:A,A2)=1 For column A, with A2 the currently active cell. HTH, Bernie MS Excel MVP "Mark" <Mark @discussions.microsoft.com wrote in message ... How do I make a rule that an identical number cannot be entered twice in an Excell column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preventing a listing of duplicate records | Excel Discussion (Misc queries) | |||
Preventing duplicate data | Excel Discussion (Misc queries) | |||
Preventing Duplicate Cells | Excel Discussion (Misc queries) | |||
Preventing Duplicate Entries within a column | Excel Discussion (Misc queries) | |||
Preventing Duplicate Entries in rows | Excel Worksheet Functions |