View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jazz - Netherlands
 
Posts: n/a
Default How do I compare lists in Excel?

I have two large lists (list1 and list2) in Excel. They both have the same
columns... and the same number of rows. In list2, differences have been made
to some of the rows. But not all.

I want to pinpoint the rows that have been changed. So, find the rows in
list2 that are different from the rows in list1.

Since these differences can occur in all of the columns (say columnA -
columnAB), I don't know in which column to check.

Can anyone help me out? Any help is appreciated!
Jazz