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.

JW wrote:
>
> 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

Dave - That worked great! Thank you very much.

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 wrote:
>>
>> 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