Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
perventing duplication of numbers on a spreadsheet
i am working on a spreadsheet ...that is very important that I don't
duplicate numbers... is there a something that i can do to provent this from happening? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
perventing duplication of numbers on a spreadsheet
Use Data Validation .. assume Column A
Allow: Custom Formula: =COUNTIF(A:A,A1)=1 apply to column or your range HTH "Nancy" wrote: i am working on a spreadsheet ...that is very important that I don't duplicate numbers... is there a something that i can do to provent this from happening? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sort out all numbers without duplication? | Excel Discussion (Misc queries) | |||
How to sort out a list of numbers without duplication? | Excel Discussion (Misc queries) | |||
Duplication | Excel Discussion (Misc queries) | |||
How-to Prevent Value Duplication | Excel Discussion (Misc queries) | |||
How do I prevent duplication of numbers in a column | Excel Discussion (Misc queries) |