Comparing two lists
 

I am using EXCEL 97.

I am wanting to compare two columns of names, if say column 'B' is different
to column 'A' then I want a third column say column 'C' to be created with
the entries which are different.

Can anyone assist me please with some code?

--
Mark

Comparing two lists
 

Look at

http://cpearson.com/excel/duplicat.htm


In article ,
"Mark" wrote:

I am using EXCEL 97.

I am wanting to compare two columns of names, if say column 'B' is different
to column 'A' then I want a third column say column 'C' to be created with
the entries which are different.

Can anyone assist me please with some code?

Comparing two lists
 

Mark wrote:

I am using EXCEL 97.

I am wanting to compare two columns of names, if say column 'B' is
different to column 'A' then I want a third column say column 'C' to
be created with the entries which are different.

Can anyone assist me please with some code?

Without VBA, but with a formula:

=A1=B1
and copy down.
Gives you TRUE when they are the same and FALSE if they are not.

Variation:
=IF(A1=B1;"";B1)
and copy down.
Gives you blanks when A and B are equal, and B if they are different.

--
Amedee Van Gasse using XanaNews 1.16.4.2
If it has an "X" in the name, it must be Linux?
Please don't thank me in advance. Thank me afterwards if it works or
hit me in the face if it doesn't. ;-)