View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dandiehl dandiehl is offline
external usenet poster
 
Posts: 12
Default two data validations for same cell

I would like to perform two unique validation on the same cell. For
instance, I would like to ensure the cells A1:A10 only contain 10 digits
(phone number) and also that there are no duplicates in the range.

Can this be done?