Extracting rows from a file based on another

  • Thread starter Thread starter Thorbjorn Sundboe
  • Start date Start date
T

Thorbjorn Sundboe

Hi,

I have 2 excel files where on is a subset of the other. All rows are
uniquely identified by a number. I would like to automatically extract the
rows in the subset from the superset, resulting in a 3rd file with the
difference between the two, like a batch operation. Do I need a utility for
this or is there an option in Excel that allows me to do this?

Cheers, Thorbjorn
 
Hi
I posted you a links as starting point in the German
newsgroup. Please post back if you have fruther question
(best would be with some example rows in plain text - no
attachment please)
 
Thanks for the link. I use Excel 2003 English. I am getting an error message
using the formula =IF(COUNTIF($A$1:$A$10,B1)=0,B1,""), it is reported as
Invalid. I have rearranged my data to correspond to the example to eliminate
errors, and also tried to enter the formula with ctrl+shift+enter.

Example A1-A10:

Peter
Paul
Mary
Melissa
James
John
Oscar
Wilfred
Henner
Ivar


Example B1-B10:
James
Paul
Mary
Melissa
Avery
John
Oscar
Henrik
Henner
Ole


In C1, I enter the formula: =IF(COUNTIF($A$1:$A$10,B1)=0,B1,"") getting
error message that formula is invalid. In my real example, I also need to
expand the ranges into more columns since I need to include address data as
well. Would appreciate any help.

Cheers, Thorbjorn
 
Hi
do you use eventually the semicolon as delimiter. If yes try
=IF(COUNTIF($A$1:$A$10;B1)=0;B1;"")
 
Thanks a lot, that did the trick for me! Schönes Wochenende aus Wien.

Cheers, Thorbjørn
 
Back
Top