Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I look for duplicate house addresses in a column in Excel?
I need to have Excel search a column of street address, street number and
name and locate any duplicates. Is it possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I look for duplicate house addresses in a column in Exc
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" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I look for duplicate house addresses in a column in Exc
Yes, it will work. Just set it up for each column where you want to spot the
duplicates. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help finding non-duplicate email addresses... | Excel Discussion (Misc queries) | |||
hide duplicate addresses in Excel | Excel Worksheet Functions | |||
How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
finding duplicate addresses | Excel Worksheet Functions | |||
Removing house numbers from addresses | Excel Worksheet Functions |