Extracting rows from a file based on another

Giganews Newsgroups
Subject: Extracting rows from a file based on another
Posted by:  Thorbjorn Sundboe (plea…@replytonewsgroup.com)
Date: Fri, 21 May 2004

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

Replies