Suppose you have a list of names in column A of two sheets in the same
workbook. Put this formula in B1 of Sheet1:

=IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"unique","Duplica ted")

and copy it down to the bottom of your list.

You could also put this formula in B1 of Sheet2:

=IF(ISNA(MATCH(A1,Sheet1!A:A,0)),"unique","Duplica ted")

and copy that down.

Then you can apply a filter to column B and select Duplicated from the
filter pull-down.

Hope this helps.

Pete

On Jan 30, 6:22*pm, Farmer Ted
wrote:
Is there a formula for this. *I want to find the duplicates in two sets of
data?



"Don Guillett" wrote:
One simplified way.

Sub findem()
For Each c In Range("b2:b6")
If Range("a2:a22").Find(c) Is Nothing Then MsgBox c & "not there"
Next c
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sharon" wrote in message
...
I have two columns of names, original list vs new list. *I want to find the
names in the new list that do not appear in the original lis.t- Hide quoted text -

- Show quoted text -