By 3rd sheet I meen a blanc sheet displaying the the result of the
comparison. In common refers to the names column A and B shares for instance
if both A and B includes names like Franc, Maria and John I want result of
the comparison to indicate that the result of the comparison are Franc, Maria
and John...

Hopefully you understand my meaning

"Jezebel" skrev:

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?