+ Reply to Thread
Results 1 to 2 of 2

[SOLVED] find identical names in list

Hybrid View

  1. #1
    chemicals-international
    Guest

    [SOLVED] find identical names in list

    We run a very long product list in Excel which is prequently updated.
    We need a formula that identifies and removes identical product names.

  2. #2
    excelent
    Guest

    RE: find identical names in list

    'Mark aktual colum, run sub

    Sub SletDubletter()
    Dim c, r, t, t2
    c = ActiveCell.Column
    r = Cells(65500, c).End(xlUp).Row
    Range(Cells(1, c), Cells(65500, c).End(xlUp)).Select
    For t = 1 To r
    If Cells(t, c) <> "" Then
    For t2 = t + 1 To r
    If Cells(t, c) = Cells(t2, c) Then
    Cells(t2, c) = ""
    End If
    Next
    End If
    Next
    Selection.Sort Key1:=Range(ActiveCell.Address), Order1:=xlAscending
    ActiveCell.Select
    End Sub

+ Reply to Thread

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