View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jakobshavn Isbrae Jakobshavn Isbrae is offline
external usenet poster
 
Posts: 78
Default Detect Duplicates

I have a list of values in B11 down to B97. The values are either numbers or
text, but there are no empty cells in the list. Is there a formula that will
give me 0 if all the values are unique and give me 1 if any of the values are
duplicated?

Thanks in advance for any help.
--
jake