Identify Unique names in Column F

rkol297

Board Regular
Joined
Nov 12, 2010
Messages
131
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hello,

I have 4000+ entries that have multiple rows with account names in column F. There are multiple entries for each account throughout the sheet, what I would like to do is keep only one row for each account out of all of the entries so that I can identify how many individual accounts had been reached throughout the year.

Basically keeping only 1 unique account name in Column F out of many account entries.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
How about
Code:
Sub removedupe()

    Dim cl As Range
    Dim Rng As Range
    
    With CreateObject("scripting.dictionary")
        For Each cl In Range("F2", Range("F" & Rows.Count).End(xlUp))
            If Not .exists(cl.Value) Then
                .Add cl.Value, Nothing
            Else
                If Rng Is Nothing Then
                    Set Rng = cl
                Else
                    Set Rng = Union(Rng, cl)
                End If
            End If
        Next cl
    End With
    Rng.EntireRow.Delete
                
End Sub
This will delete the entire row, for all duplicates. If that is not what you want, let me know
 
Upvote 0
If you want VBA:

Code:
Sub removeduplicates()
Cells.removeduplicates Columns:=6, Header:=xlYes
End Sub

This can also be done manually, with Remove Duplicates on the Data tab
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top