Re: Listing changes between two lists

Thanks!!!

That was tremendously simpler than I had imagined it would be.

-Jeff



"Peo Sjoblom" <terre08@xxxxxxxx> wrote in message
news:u5RCiMtUFHA.3292@xxxxxxxxxxxxxxxxxxxxxxx
> http://www.cpearson.com/excel/duplicat.htm
>
> tagging them sounds like it could work for you
>
> --
> Regards,
>
> Peo Sjoblom
>
>
> "Jeff P" <jeffpNO@xxxxxxxxxxxxxxxxx> wrote in message
> news:117onqeke1hl027@xxxxxxxxxxxxxxxxxxxxx
>>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
>> work***). I also want a seperate list of new records (those that now
>> exist in this week's work*** but did not exist in the older work***
>> 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
>>
>


.