Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing two lists and removing duplicatations
I have 2 workbooks each containing long lists of names and addresses.
I need to compare the surname in column B and the first line of the address in column D of workbook 1 with the list in workbook 2 (columns C and D). If the same info occurs in workbook 2 I want to delete the entire line from that list. Can you help please? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing two lists and removing duplicatations
I would use a helper column that concatenated the two fields into one:
=b2&"...."d2 in both files. Then I'd be able to base my comparisons on just one column. Then I'd visit Chip Pearson's site: http://www.cpearson.com/excel/duplicat.htm He has lots of techniques to work with duplicates: Alan M wrote: I have 2 workbooks each containing long lists of names and addresses. I need to compare the surname in column B and the first line of the address in column D of workbook 1 with the list in workbook 2 (columns C and D). If the same info occurs in workbook 2 I want to delete the entire line from that list. Can you help please? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing and removing data in different workbooks | Excel Worksheet Functions | |||
Comparing Lists | Excel Worksheet Functions | |||
comparing lists | Excel Worksheet Functions | |||
Comparing two lists | Excel Programming | |||
Comparing Lists to Partial Lists | Excel Programming |