Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I am trying to add validation that willl do the following: 1. Prevent duplicate values being entered into a cell. 2. Only allow a 10 digit number being entered into a cell. I know how to add these methods individually, but is it possible to set both validation principles together on a cell or range of cells? I would be most grateful for any help provided. Many thanks, John. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Refresh existing data when changed in data validation list | New Users to Excel |