What are you looking for?

If you want to find out if each cell in Column A of sheet1 appears in column A
of sheet2, you could use a helper column of formulas:

=isnumber(match(a1,sheet2!a:a,0))
and drag down

And you could use the same kind of formula that will tell you if values in
sheet2 appear in sheet1.

Chip Pearson has lots of info about working with duplicates at:
http://www.cpearson.com/excel/duplicat.htm

Dan wrote:

How can I compare a column from worksheet 1 to a column in worksheet 2 of the
same work book?

--

Dave Peterson