| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
limit validation list to prevent dups
I am using a validation list and need to restrict it so that for each column
in a worksheet, the items in the list may only be used once. The validation list is used for 14 columns but these columns are used to create a list in another worksheet and I need to ensure that the same value is not used twice in any given column. |
|
#2
|
|||
|
|||
|
limit validation list to prevent dups
Hi Sonya,
Try the following link from Mr. Excel : http://www.mrexcel.com/tip008.shtml Step by step instructions and it's very useful ! Cheers, Kevin Lehrbass www.spreadsheetsolutions4u.com "Sonya" wrote: I am using a validation list and need to restrict it so that for each column in a worksheet, the items in the list may only be used once. The validation list is used for 14 columns but these columns are used to create a list in another worksheet and I need to ensure that the same value is not used twice in any given column. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expanding Data validation from List | Excel Discussion (Misc queries) | |||
| validation list with drop down list of options?? | Excel Worksheet Functions | |||
| How to dynamically select a validation list from data in a cell? | Excel Discussion (Misc queries) | |||
| Data Validation lists - entering value not in list | Excel Discussion (Misc queries) | |||
| Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
Linear Mode
