View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ABM ABM is offline
external usenet poster
 
Posts: 2
Default Determine if column contains duplicate value

Is there a way to determine if a column range contains a duplicate value
with a formula in one cell? The formula would return 1 if there are no
repeating values and 0 if a value is found more than once.