![]() |
#11
|
|||
|
|||
![]()
No concerns at all!
I just noted the bug you mentioned and the non-ability of my code to discover names like: Juan Carlos Primero -- Juan Primero Carlos aa bb cc dd ee ff gg -- ff gg cc aa bb ee dd and so on. Then this new code: ========================= Public Sub Test() Dim k As Long, Split_1, Split_2 Dim h, i, j, n, SR As Range Set SR = [Sheet1!A2:A26] k = 1 For Each i In Range(SR(1), SR(SR.Count - 1)) k = k + 1 Split_1 = Split(i, " ") For Each j In Range(i(k), SR(SR.Count)) Split_2 = Split(j, " ") If UBound(Split_1) = UBound(Split_2) Then k = 0 For Each h In Split_1 For Each n In Split_2 If h = n Then k = k + 1 End If Next If k = UBound(Split_1) + 1 Then MsgBox i & " " & j & vbCrLf & _ i.Address & " " & j.Address End If Next End If Next k = 1 Next End Sub ====================== Your opinion would be much appreciated Bruno |
Tags |
duplicate entries |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Extract duplicates in table | goran.c | Excel | 0 | 01-21-2015 12:47 AM |
![]() |
mnut | Excel Programming | 1 | 10-17-2014 10:05 PM |
Mail duplicates | mixy | Outlook | 0 | 02-10-2011 12:54 AM |
![]() |
JoJo | Outlook | 1 | 01-28-2011 04:39 PM |
![]() |
zxmax | Excel | 1 | 09-29-2006 08:29 PM |