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.
|