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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have Excel search a column of street address, street number and
name and locate any duplicates. Is it possible?
 
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.
 
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?
 
Back
Top