I’m comparing two lists in Excel 2002. Each list has 5000+ rows and 5
columns. Each record (row) has a unique ID number. So first I need to
compare the two columns that have that ID number and tag anything that’s on
one list and not on the other.

Next, I need to compare the other columns in the rows that correspond to
matching ID numbers and tag any data that is different.

I think I can manage to do one of these tasks, but I can’t do both. I’ve
tried sorting the lists by the ID number so the two lists will correspond,
but once I’ve found a record in one list that’s not on the other list, the
following records no longer line up and I can’t compare the data in the other
cells. The extra row (or missing row) can be on either of the lists.

I HOPE this is an obvious problem and someone can help me. Thanks for your
help!