"ClaireView" <froufle@notthishotmail.com> wrote in message
news:13A02D05-775D-4A5B-BAAB-3A4F1BDB9941@microsoft.com...
> 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!
>

Is it possible the item on list 1 needs to be compared against multiple
records in list 2 (more than one possible match)?