![]() |
|
#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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Extract duplicates in table | goran.c | Excel | 0 | 01-21-2015 12:47 AM |
Adding duplicates as comments
|
mnut | Excel Programming | 1 | 10-17-2014 10:05 PM |
| Mail duplicates | mixy | Outlook | 0 | 02-10-2011 12:54 AM |
Inbox and subfolder duplicates
|
JoJo | Outlook | 1 | 01-28-2011 04:39 PM |
sum of duplicates
|
zxmax | Excel | 1 | 09-29-2006 08:29 PM |