Thread: Finding duplicates in column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default Finding duplicates in column
Assuming the data is in column A, add a formula in column B of

=IF(COUNTIF($A$1:$A1,$A1)1,"Duplicate","")

Cpy that down, then you can filter column B for Duplicate


Reply With QuoteReply With Quote