Cell Compare

wally0206 · Oct 4, 2004

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 · Oct 4, 2004

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