View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jonah
 
Posts: n/a
Default Validate in WS to prevent dual data entry

How do I validate that the data entered in a worksheet is not a
duplicate from a list of 150 names. I have two columns with the same
list, and need a way to prevent dual entries.

Jonah