Is it possible to compare wo sheets of data in excel.

Example

Column A sheet 1 contains various names (members)
Column B sheet 2 also contains various names.

The names are not Necessarily in the same order in both columns and are not
all identical.

Is it possible to compare the two column and find the names in common
eventhough they are not in the same order in a 3rd sheet?