Assuming that you have named the two ranges list1 and list2

Sub DeleteDuplicates()
Dim iRows As Long
Dim iStartRow As Long
Dim i As Long

iRows = Range("list1").Rows.Count
iStartRow = Range("list1").row
For i = iRows + iStartRow - 1 To iStartRow Step -1
If Not IsError(Application.Match(Cells(i, "A").Value,
Range("list2"), 0)) Then
Rows(i).Delete
End If
Next i
End Sub


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"rtek" wrote in message
...

Please help, is there any way to do this? i will try to explain..

I have 2 huge lists. One is " the Master list" which I have to extract
items that are not already listed on the second list . I don't want to
remove duplicate entries,I want to remove the duplicates completely. in
both lists, so that I only have items that are not in the second
list...I did some searchin but i would really appreciate if someone
helped me..

like this..

List 1:
# $ % & * ! @
List 2:
# & @

so I want to end up with:
$ % * !


--
rtek
------------------------------------------------------------------------
rtek's Profile:
http://www.excelforum.com/member.php...o&userid=34483
View this thread: http://www.excelforum.com/showthread...hreadid=542432