Select Records that appear in multiple columns

[Chase]

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!

[FDibbins]

select them and do what, when found?

[Chase]

select them then sort by row.

so if a record in column A matched a record in column B, sort the sheet so that all rows where column a matches a record in column b can be sorted. I need to separate rows where A=B, so say if I have 400 rows out of 1000 where A=B I would want those 400 rows to be sorted to the top of the sheet.