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

G

Guest

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

Guest

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.
 
G

Guest

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?
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to sort addresses in microsoft excel 2
How to combine two columns into a new column 2
How do you alphabetize street addresses within a column? 1
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
Match Account ID from combining street names and numbers 1
text to column 6
Sorting characters, ignoring numbers 7
MID, LEFT, RIGHT help 5

Top