Thread: Identifying unique dates in a row of cells containing dates...
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Identifying unique dates in a row of cells containing dates...
Hi,

=IF(MATCH(A1,$A$1:$H$1,0)=COLUMN(A1),"Unique","Not Unique")

should do the job ...

HTH
Cheers
Carim

Reply With QuoteReply With Quote