Thread: how do I look for duplicate house addresses in a column in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jovan Timotijevic[_2_] Jovan Timotijevic[_2_] is offline
external usenet poster
  
Posts: 12
Default how do I look for duplicate house addresses in a column in Excel?
This was discussed many times...

Try to add Conditional Formatting to whole column of addresses (let's say it
is col A).

=COUNTIF($A$1:$A$100,A1)1

Add some fill color and all the cells that have the same value will be
colored. I assumed that you have 100 rows in column A.
Reply With QuoteReply With Quote