I am trying to select records in column A that appear in column B

so for example:
column a:
dog
cat
bird
snake

column B:
insect
mouse
cat
dog


cat and dog would be selected in column A.

help would be appreciated, thanks!