![]() |
|
#4
|
||||
|
||||
|
You could try a macro like:
Code:
Sub DeleteDuplicates()
Application.ScreenUpdating = False
Dim LRow As Long, i As Long, j As Long, k As Long, bDel As Boolean
With ActiveSheet
LRow = .Cells.SpecialCells(xlCellTypeLastCell).Row
For i = LRow To 2 Step -1
For j = i - 1 To 1 Step -1
If .Cells(i, 1).Value = .Cells(j, 1).Value Then
If .Cells(i, 2).Value = .Cells(j, 2).Value Then
For k = 3 To 6
If .Cells(i, k).Value <> "" Then
bDel = True
Exit For
End If
Next
If bDel = True Then
.Rows(j).EntireRow.Delete
Else
.Rows(i).EntireRow.Delete
End If
End If
End If
Next
Next
End With
Application.ScreenUpdating = True
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
| Tags |
| consolidate, duplicates, list |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
matching names in column A with names in column C
|
bob999999 | Excel | 1 | 04-28-2013 11:21 AM |
| Consolidate - does not work in 2007 version | Jirik61 | Excel Programming | 10 | 08-08-2012 04:59 AM |
| names on bars | Psychopig7 | Project | 1 | 06-22-2012 04:58 AM |
| How to enter names in Resource Pool/names | pstein | Project | 1 | 03-26-2012 07:37 AM |
| Names | dguillory | Word | 0 | 12-29-2009 11:00 PM |