Cell Compare

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wally0206 - 04 Oct 2004 18:18 GMT

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:D to list what is in B:B but not in A:A, thank
for any info

Reply to this Message

Debra Dalgleish - 04 Oct 2004 22:14 GMT

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

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

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message