View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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?