Link to home
Avatar of al4629740
al4629740Flag for United States of America

asked on

comparing records from one excel sheet to another

I have an excel sheet of records.  Every month I recieve a new sheet of updated records.  I want to see which records are new, but I don't have any way of noticing them.  Is there a way to compare the two excel sheets and note only the changes that have been added?
Avatar of nutsch
nutsch
Flag of United States of America image

Do you have a unique ID that you could run a match on ?

Also, check out this excellent article by Dave Brett, which will give you the add-in and the knowledge to easily compare two worksheets.

Thomas
Avatar of al4629740

ASKER

yes.  there is an EIN column
So the easy way, if I understand your problem statement, is to use a MATCH function on every row in the new sheet and search for the EIN in the column on the old sheet that contains the EIN.  Make sure your 3rd parameter in the MATCH is 0, for an exact match.  The formula will return an error for every EIN in the new sheet not found in the old.  You can process the error condition to your liking (via an IF statement, etc).
Can you post samples of data?
I just posted a sample.  I will be comparing this exact sheet which gets additions each month.
Did you try the match function?  Searching for a value in a list is it's purpose - one that it accomplishes with ease.  It will let know know, when searching for an exact match (vs the closet value) whether one is found or not.  Using it, you can definitively tell the new EIN numbers added each period.
If I have two different sheets though, how would I compare the first sheet with the second sheet
SOLUTION
Avatar of AgeOfEmpires
AgeOfEmpires
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Are you trying to check that all cells are the same, or just that a line didn't exist previously?
that a line didn't previously exist compared to the old sheet.

The sheet gets added to monthly and then they send me the whole new one each month
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.