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

How do I compare lists in Excel?
 

Assuming that the "Lists" are tabs and the same type of information is in
each cell but what's in it has changed, meaning Chris changed to Christopher,
you could set up another tab to look for the changes per cell. Use a formula
such as:

=IF(Sheet1!A1=Sheet2!A1,"","Change")

Place this formula in every cell and then scan for which cell changed.

"Jazz - Netherlands" wrote:

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

How do I compare lists in Excel?
 

But that would mean that I would have to check every cell individually,
wouldn't it? I have about 9000 rows and 28 columns.

Is there an easier way to check a complete row of 'tab1' against a complete
row of 'tab2'?

Thanks,

Jazz

"jeffstew1" wrote:

Assuming that the "Lists" are tabs and the same type of information is in
each cell but what's in it has changed, meaning Chris changed to Christopher,
you could set up another tab to look for the changes per cell. Use a formula
such as:

=IF(Sheet1!A1=Sheet2!A1,"","Change")

Place this formula in every cell and then scan for which cell changed.

"Jazz - Netherlands" wrote:

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