Comparing two worksheets

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

I am wondering if there is a way to compare a column with
in one worksheet with a column in another worksheet. I am
trying to find the common data based upon the data
contained in the column.
 
you can use a formula for this

open both workbooks.

In one workbook put in the formula in B1 for example

=countif([OtherBook.xls]Sheet1!$A:$A,A1)

then drag fill down the column

Any cell in column B that has a value other than 0 matches to the other
workbook.
 
Back
Top