Reconciling Lists
 

Good Afternoon,

I have found many variants of what I am trying to do but cannot find a
solution that fits the exact needs of our project. I am hoping that someone
can point me in the right direction and I can go from there.

I have two reports, a previous week and a current week. I need to create one
combined report that shows which records 'dropped' off, which had no change,
and which were added.

Currently, I have created a unique identifier for both lists so any lookup
or countif functions only have to be done on one column. What I can't figure
out is how to merge the lists with only the new data. Has anyone else
encountered this previously?

Thank you in advance for any help you can offer,

Katie