View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Identifying unique dates in a range of cells containing dates...

Here's how to do the first part:
=IF(COUNTIF(B1:H1,A1)=0,"Unique", "Not unique")

There's a logic problem in the second part of your question: "to tell
me if the date in cell B1 is unique in comparison to all the other
dates in the range A1 through H1". B1 is included in that range. Or
do you need to check if B1 is repeated in A1 and C1:H1?