Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find duplicate entries
I have two columns in an Excel spreadsheet that consist of an address in each
column. Most of the addresses are identical but I wish to find the rows where the addresses are not identical. Is there a way to do this. Thanks for any help. Kris |
#2
|
|||
|
|||
Hi,
One way would be to conditional format one column so it highlights if it doesn't equal the corresponding cells in the other column. HTH Ron "kharrison" wrote: I have two columns in an Excel spreadsheet that consist of an address in each column. Most of the addresses are identical but I wish to find the rows where the addresses are not identical. Is there a way to do this. Thanks for any help. Kris |
#3
|
|||
|
|||
If you want help working with duplicates, take a trip to Chip Pearson's
site: http://www.cpearson.com/excel/duplicat.htm He has a bunch of techniques for working with duplicates. kharrison wrote: I have two columns in an Excel spreadsheet that consist of an address in each column. Most of the addresses are identical but I wish to find the rows where the addresses are not identical. Is there a way to do this. Thanks for any help. Kris -- Dave Peterson |
#4
|
|||
|
|||
Can you explain how I would go about doing that.
Thanks "Airfive" wrote: Hi, One way would be to conditional format one column so it highlights if it doesn't equal the corresponding cells in the other column. HTH Ron "kharrison" wrote: I have two columns in an Excel spreadsheet that consist of an address in each column. Most of the addresses are identical but I wish to find the rows where the addresses are not identical. Is there a way to do this. Thanks for any help. Kris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicate rows then deleting them | Excel Worksheet Functions | |||
Preventing Duplicate Entries within a column | Excel Discussion (Misc queries) | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
Another question on how to find duplicate data | Excel Worksheet Functions | |||
Add numbers for duplicate entries then delete | Excel Worksheet Functions |