Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Merging data lists - PLEASE HELP!!
I am trying to merge two data lists containing name, address, city, st, zip
information. Is there a way for Excel to automatically delete duplicate entries? Or do I have to go through the spreadsheet and manually delete each duplicate entry? HELP! |
#2
|
|||
|
|||
Here's one way to do it.
1. Make a backup of your data so you have a fallback position in case something goes horribly wrong. 2. Suppose your data is set up like this: Name in column A, Address in Column B, City State Zip in column C, phone number in D. Alpha sort column A so the names are in alphabetical order. 3. Insert a new column B so that column B is blank and addresses are in col C. 4. In cell B2 (assuming this is the second address in your list) enter the formula =IF(A2=A1,"xxxxx","") This checks the current entry to see if it matches the previous entry, and marks it with xxxxx when it matches. 5. Copy column B and paste it over itself as values. 6. Alpha sort column B and delete all rows with xxxxx in column B. 7. Alpha sort the remainder on column A. |
#3
|
|||
|
|||
Take a look at Chip Pearson's site regarding duplicates:
http://www.cpearson.com/excel/duplicat.htm -- Sincerely, Michael Colvin "CGuerrera" wrote: I am trying to merge two data lists containing name, address, city, st, zip information. Is there a way for Excel to automatically delete duplicate entries? Or do I have to go through the spreadsheet and manually delete each duplicate entry? HELP! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
merging and formating data | New Users to Excel | |||
Shuffling Data To Make Lists Match | Excel Worksheet Functions | |||
Should Merging workbooks pick up new data or only edited data? | Excel Worksheet Functions |