comparing a column in two separate spreadsheets

C

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
 
B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing data (conditionally) between two spreadsheets 3
joining spreadsheets together for reports and queries? 1
copy one column of data after another 7
Concatinating two spreadsheets by a column 4
Comparing 2 Spreadsheets 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
comparing columns in two spreadsheets 1
Excel 2003 VBA In directory Open Spreadsheets Extract data 1

Top