Comparing Data in Two Excel Spreadsheets

  • Thread starter Thread starter JW
  • Start date Start date
J

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.
 
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.
 
Dave - That worked great! Thank you very much.

Dave Peterson said:
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.
Click to expand...
 
Back
Top