comparing a column in two separate spreadsheets
 

Hello:

I have two spreadsheets which have almost identical columns, in terms of the
data contained in each sheet.

I want to filter out of spreadsheet "B" the data in its first column that
matches the data in the first column of spreadsheet "A". You see,
ultimately, I'm trying to find data in spreadsheet "B" that does not match
data in spreadsheet "A". The best way is to filter based on the first column
of each.

How do I do this?

childofthe1980s

comparing a column in two separate spreadsheets
 

=IF(ISERROR(MATCH(A2,B!$a$2:$a$30067,0)),"new","ma tch ")

A2 would be the cell ref you are matching against the column in spreadsheet A.



"childofthe1980s" wrote:

Hello:

I have two spreadsheets which have almost identical columns, in terms of the
data contained in each sheet.

I want to filter out of spreadsheet "B" the data in its first column that
matches the data in the first column of spreadsheet "A". You see,
ultimately, I'm trying to find data in spreadsheet "B" that does not match
data in spreadsheet "A". The best way is to filter based on the first column
of each.

How do I do this?

childofthe1980s

comparing a column in two separate spreadsheets
 

Thanks, Bob! That's exactly what I needed!

childofthe1980s

"Bob" wrote:

=IF(ISERROR(MATCH(A2,B!$a$2:$a$30067,0)),"new","ma tch ")

A2 would be the cell ref you are matching against the column in spreadsheet A.



"childofthe1980s" wrote:

Hello:

I have two spreadsheets which have almost identical columns, in terms of the
data contained in each sheet.

I want to filter out of spreadsheet "B" the data in its first column that
matches the data in the first column of spreadsheet "A". You see,
ultimately, I'm trying to find data in spreadsheet "B" that does not match
data in spreadsheet "A". The best way is to filter based on the first column
of each.

How do I do this?

childofthe1980s