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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin S - 19 Jun 2007 02:15 GMT

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

Reply to this Message

Jovan Timotijevic - 19 Jun 2007 08:08 GMT

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 to this Message

Kevin S - 19 Jun 2007 19:32 GMT

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?

> This was discussed many times...
>
[quoted text clipped - 5 lines]
> 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 to this Message

Jovan Timotijevic - 19 Jun 2007 21:15 GMT

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

Reply to this Message