J
Jeff P
I have two lists of records in two different worksheets. They are basically
the same information except one is a newer version of the same report I am
able to get weekly a copy of in the form of a CSV. A few records may have
been added and a few records may have been deleted since last week's CSV was
given to me. Some records may have had corrections made to various cells.
However, all records have a unique identifer in the form a text string such
as "000-1234-123A". This number / text string is always the same for
matching records that exist in both worksheets. There are never any records
that share duplicate identifier strings.
If I just pick any old record and manually type in it's identifer string, I
can use the lookup function to go find it in one of these lists and give me
all the data from that row. However, I can't figure out how to get it to
repeat the lookup function again and again so that it would try to find all
of the identifiers from the first list by searching for them in the second.
Likewise, I don't want to get a listing of matches. I want a list of
mismatches. That is, I want one list of records that have been removed
(those that existed last week but do not exist in this week's worksheet). I
also want a seperate list of new records (those that now exist in this
week's worksheet but did not exist in the older worksheet from last week.)
Does anybody have an idea how to easily compare two lists and return all the
rows that exist in one but not the other?
Thanks,
Jeff Phillips
the same information except one is a newer version of the same report I am
able to get weekly a copy of in the form of a CSV. A few records may have
been added and a few records may have been deleted since last week's CSV was
given to me. Some records may have had corrections made to various cells.
However, all records have a unique identifer in the form a text string such
as "000-1234-123A". This number / text string is always the same for
matching records that exist in both worksheets. There are never any records
that share duplicate identifier strings.
If I just pick any old record and manually type in it's identifer string, I
can use the lookup function to go find it in one of these lists and give me
all the data from that row. However, I can't figure out how to get it to
repeat the lookup function again and again so that it would try to find all
of the identifiers from the first list by searching for them in the second.
Likewise, I don't want to get a listing of matches. I want a list of
mismatches. That is, I want one list of records that have been removed
(those that existed last week but do not exist in this week's worksheet). I
also want a seperate list of new records (those that now exist in this
week's worksheet but did not exist in the older worksheet from last week.)
Does anybody have an idea how to easily compare two lists and return all the
rows that exist in one but not the other?
Thanks,
Jeff Phillips