Pete, thanks. that works....I was wondering is there a way to pull a line
out (say column c1) (Tab1) and have it apear in tab 2 if there is a
duplicate? So If Both Tab 1 and Tab 2 have a duplicate a value in Column C1
will be moved over to sheet 2 (Tab 2)?

"Pete_UK" wrote:

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 -