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.

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.