comparing a column in two separate spreadsheets

[childofthe1980s]

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

 

[Bob]

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

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

 

[childofthe1980s]

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

childofthe1980s