Comparing columns and extracting data

I've got two columns with lots of data in each. Some unique, some the
same. Short example:
Col A
cat
cow
dolphin
dog
fish
horse
snake
zebra

Col B
bear
cow
dolphin
dog
fish
hamster
monkey
zebra

I would like to create additional columns with the following
stipulations:

Col C (what's common in both A & B)
Col D (what's in A but not B)
Col E (what's in B but not A)

Any help is appreciated.
.

Relevant Pages

  • Re: The fossil record confirms Ray and Linnaeus not Devils Advocate
    ... We can observe this kind of evolution, we can even manipulate it ourselves. ... But if you think a fish can eventually gave rise to another "kind" such as a dog, well, you are sadly mistaken with your science. ... That has never been observed, not can we repeat it, nor can we manipulate it. ...
    (talk.origins)
  • Re: Humiliation redefined
    ... many people won't eat salmon and just feed it to their dogs. ... Seems a waste to me because I will eat any fish. ... Depending on where one lives, there are King, Red, Silver, Chum ... But what you've heard about is Chum (aka Dog Salmon), ...
    (sci.med.transcription)
  • Re: Humiliation redefined
    ... many people won't eat salmon and just feed it to their dogs. ... Seems a waste to me because I will eat any fish. ... Depending on where one lives, there are King, Red, Silver, Chum ... But what you've heard about is Chum (aka Dog Salmon), ...
    (sci.med.transcription)
  • Re: Humiliation redefined
    ... many people won't eat salmon and just feed it to their dogs. ... Seems a waste to me because I will eat any fish. ... Depending on where one lives, there are King, Red, Silver, Chum ... But what you've heard about is Chum (aka Dog Salmon), ...
    (sci.med.transcription)
  • Re: Humiliation redefined
    ... many people won't eat salmon and just feed it to their dogs. ... Seems a waste to me because I will eat any fish. ... But what you've heard about is Chum (aka Dog Salmon), ...
    (sci.med.transcription)