Cell Compare

[wally0206]

I have cell A:A and B:B, and i want C:C to list what is in A:A but no
in B:B, and I want D to list what is in B:B but not in A:A, thank
for any info

 

[Debra Dalgleish]

Chip Pearson has information on working with lists. There's a formula
here to extract values that are in one list, and not another:

http://www.cpearson.com/excel/duplicat.htm#InOneNotOther