Thread: Duplicates formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Duplicates formula
In B1:
=REPT(COUNTIF($A$1:A1,A1),A1<A2)
Copy down ...

Regards,
Bernd
Reply With QuoteReply With Quote