Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. ;-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing lists | New Users to Excel | |||
Comparing two lists | Excel Discussion (Misc queries) | |||
Comparing to lists | Excel Discussion (Misc queries) | |||
Comparing lists | Excel Worksheet Functions | |||
Comparing Lists to Partial Lists | Excel Programming |