| 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) | |||
Hybrid Mode
