It's possible, but you'd need to do a lot more work on the specification
first. What's the "3rd sheet" ? What *exactly* do you mean by "in common"?



"kittymis" wrote in message
...
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?