View Single Post
  #1   Report Post  
Sonya
 
Posts: n/a
Default 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.