Comparing Data in Two Excel Spreadsheets

[JW]

I'm using Excel 2002. I have two spreadsheets, each has a column containing
account numbers. I would like to be able to identify any account numbers in
spreadsheet #2 that are also present in spreadsheet #1. I do NOT want to
merge the spreadsheets. Any good way of doing that?

If it's easier, I could also get by creating a third, temporary spreadsheet
that has only the two columns of account numbers, and eliminate any account
numbers in column B that match any account numbers in column A. Any good way
of doing that?

Thanks very much for your help.

 

[Dave Peterson]

You could add a helper column in sheet2 and put a formula like:

=isnumber(match(a1,sheet1!a:a,0))

You'll see TRUE if it exists. False if it's missing.

Adjust sheet names and addresses to match your data.

 

[JW]

Dave - That worked great! Thank you very much.

You could add a helper column in sheet2 and put a formula like:

=isnumber(match(a1,sheet1!a:a,0))

You'll see TRUE if it exists. False if it's missing.

Adjust sheet names and addresses to match your data.