Duplicate Numbers in Column

[shehla.uhp1]

Hi,

I am looking for excel function that help me to delete duplicate part numbers in the column.

Thanks.

 

[Robert Mika]

If you mean formula there is no such (you can check if you have duplicates in next column)but if your data are in column A use this VBA solution

Sub DeleteDups()
     
    Dim x               As Long
    Dim LastRow         As Long
     
    LastRow = Range("A65536").End(xlUp).Row
    For x = LastRow To 1 Step -1
        If Application.WorksheetFunction.CountIf(Range("A1:A" & x), Range("A" & x).Text) > 1 Then
            Range("A" & x).EntireRow.Delete
        End If
    Next x
     
End Sub

 

[shehla.uhp1]

If you mean formula there is no such (you can check if you have duplicates in next column)but if your data are in column A use this VBA solution

Sub DeleteDups()
     
    Dim x               As Long
    Dim LastRow         As Long
     
    LastRow = Range("A65536").End(xlUp).Row
    For x = LastRow To 1 Step -1
        If Application.WorksheetFunction.CountIf(Range("A1:A" & x), Range("A" & x).Text) > 1 Then
            Range("A" & x).EntireRow.Delete
        End If
    Next x
     
End Sub

I don't know about VBA.I am looking simple excel formula.

Thanks.

 

[Robert Mika]

There is no formula that will delete duplicatates.
You can find duplicates using simple MATCH or try to use Remove Duplicates tool from Excel option.
Do not be afraid of VBA.
Press ALT+F11 go to the left hand side of the window and eter this code under sheet where you have got your data.

 

[iyyi]

you can choose Data>Remove Duplicates from the excel menu.

 

[shehla.uhp1]

Thanks.Now solved.