how do I look for duplicate house addresses in a column in Excel?

[Kevin S]

I need to have Excel search a column of street address, street number and
name and locate any duplicates. Is it possible?

 

[Jovan Timotijevic]

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.

 

[Kevin S]

I can start with just a few rows, but will add to it each day, about 100 each
day. Column B will have the house address, and I need to know if duplicates
are being added each day, and which ones they are. Column C will be either
the same address or a different address, depending on how the mail was set
up. I will need to search column C for duplicates also. After 5 days I will
start a new spreadsheet. Will this work?

 

[Jovan Timotijevic]

Yes, it will work. Just set it up for each column where you want to spot the
duplicates.