Results 1 to 5 of 5

Unique List 2 or more columns

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-29-2008
    Location
    New York
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    145

    Unique List 2 or more columns

    Hi,
    I'm trying to modify a code written by DonkeyOty that I found here:
    HTML Code: 
    Sub UniqueOrder() 
    Dim LR As Long, i As Long
    Dim xlCalc As XlCalculation
    LR = Cells(Rows.Count, "C").End(xlUp).Row
    With Application
        xlCalc = .Calculation
        .Calculation = xlCalculationManual
        .ScreenUpdating = False
        .EnableEvents = False
        For i = LR To 2 Step -1
            If .CountIf(Columns("C"), Cells(i, "C")) > 1 Then Rows(i).EntireRow.Delete
        Next i
        .Calculation = xlCalc
        .ScreenUpdating = True
        .EnableEvents = True
    End With
    End Sub
    I have data in columns A and B, and I concatenated Columns A and B in column C, and used the code to make the unique list.
    Is there a way this could be done without using column C?
    I've attached a sample file.
    Thanks,
    Xrull
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1