Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-13-2013, 07:10 PM
macropod's Avatar
macropod macropod is offline Consolidate names Windows 7 64bit Consolidate names Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
 

Tags
consolidate, duplicates, list

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Consolidate names 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft