compare two sheets

[Guest]

Hi all

I have two spreadsheets pulled from a database at different times (half
yearly). Is there a way to compare and contrast the two sheets (or more than
2 if possible). I what it to look at the list and tell me what records are
missing (from the new one)

any help greatly appreciated

Kind regards

Rexmann

 

[Guest]

See if you can find something suitable here:

http://www.cpearson.com/excel/duplicat.htm

 

[Guest]

One way is to use the MATCH function to match two pieces of data between the
two lists. Anywhere you get an error as opposed to a row reference returned,
you have a new record. More info here:
http://www.techonthenet.com/excel/formulas/match.php

Dave