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

=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" 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

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

childofthe1980s

"Bob" wrote:

> =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" 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