| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation using Unique Values
In column A, I have numbers which are the sum of integer multiples of
numbers ( 3 and 6 in this case) e.g. 9, 3, 9, 12, 3, 9, 12, etc In column B, I want to use Data Validation to restrict input to one of the values in column H, but I want the Data Validation drop down to display only the unique values €“ 3,9,12. Can I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Obtaining Unique Number From Data Validation List | Excel Discussion (Misc queries) | |||
| Unique entry - Data Validation | Excel Discussion (Misc queries) | |||
| DataValidationList - Unique Entries | New Users to Excel | |||
| Unique numbers from data validation list | Excel Worksheet Functions | |||
| Data Validation dependant and unique | Excel Worksheet Functions | |||
Threaded Mode
