Comparing Data in Two Excel Spreadsheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JW - 01 Dec 2006 15:00 GMT

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.

Reply to this Message

Dave Peterson - 01 Dec 2006 15:25 GMT

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.

> 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
[quoted text clipped - 7 lines]
>
> Thanks very much for your help.

Signature

Dave Peterson

Reply to this Message

JW - 01 Dec 2006 21:05 GMT

Dave - That worked great! Thank you very much.

> You could add a helper column in sheet2 and put a formula like:
>
[quoted text clipped - 20 lines]
>>
>> Thanks very much for your help.

Reply to this Message

Rate this thread: